Question: Write SQL statements for following given Employee table: table [ [ Column , Type,Key,Extra ] , [ Emp _ Id , NO , PRI,

Write SQL statements for following given Employee table:
\table[[Column,Type,Key,Extra],[Emp_Id,NO,PRI,],[Emp_Name,NO,,],[Age,YES,,Age must be],[City,YES,,],[JobTitle,YES,,]]
Write a SQL statement to create above table with appropriate datatype and with the mentioned constraints. (3)
Write a SQL statement to add a new column "State" of datatype varchar with size 20 to the table Employee. (1)
Write a SQL query to "Display employee id, employee name whose third letter "g" and are at least 4 characters in length" from the Employee table". (1)
Write a SQL query to "Display employee details who are working as an "Instructor" in "Toronto". (1)
Write a SQL query to "Delete Age column from Employee table". (1)
Write a SQL query to "Change City column size". (1)
 Write SQL statements for following given Employee table: \table[[Column,Type,Key,Extra],[Emp_Id,NO,PRI,],[Emp_Name,NO,,],[Age,YES,,Age must be],[City,YES,,],[JobTitle,YES,,]]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!