Computer Science
Drop table Employee and Department.
DDL & DML
1 Like
Answer
DROP TABLE IF EXISTS Employee ;
DROP TABLE IF EXISTS Department ;
Answered By
2 Likes
Related Questions
Populate the table Department with data from table dept. Including only required columns.
Create the table Employee based on the following table instance chart.
Column Name Data Type Length ID NUMBER 8 First_Name VARCHAR 25 Last_Name VARCHAR 25 Dept_ID NUMBER 8 Create table Customer as per following Table Instance Chart.
Column Name Data Type Length Cust_ID NUMBER 7 Cust_Name VARCHAR 30 Cust_Address1 VARCHAR 20 Cust_Address2 VARCHAR 30 Pincode NUMBER 6 Cust_Phone VARCHAR 10 Add one column Email of data type VARCHAR and size 30 to the table Customer.