Question

Write sql queries for the following.
1. Make the EmpDB as current database
2. Write a sql query to show the description of 'Employee' table.
3. Add a new column 'salary' for 'Employee' table it should accept 5 digits only.
4. Insert the following 5 records in Employee table.
Assignments
©
Calendar
Emp_id
Emp_name
SMITH
Dept_name
CLERK
Hire_date
1980-12-17
Salary
50000
7369
7499
ALLEN
SALESMEN
1981-02-20
45000
7521
WARD
SALESMEN
1981-02-21
40000
7566
JONES
MANAGER
1981-04-20
60000
7654
MARTIN
SALESMEN
1981-09-28
35000
5. Change the column name 'salary' to 'emp_salary'.
6. Modify the column 'emp_salary' to accept 7 digits.
7. Delete the column 'emp_salary'.
8. Delete 'Employee' table.
9. Delete 'EmpDb' database.

Answer 1

m ஒ,ஓகுயமழோநற்அன

ஔஔVn.rsj

sgc