Informatics Practices > Database Query using SQL > Querying And Grouping

(i) Write SQL command to create a table

with following specifications:

• EMPID
  - To store Employee ID, An integer value and a primary key.
• EMPNAME
  - To store name of employee, A variable character value with maximum 40 characters.
• DOB
  - To store date of birth of employee.
• Salary
  - To store salary of employee, total 10 digits, 2 digits after decimal.
• Subject
  - To store subject taught, 30 fixed characters.

(ii) Also write SQL command to remove the table from the database.