Computer Science
Drop the column CustomerIncomeGroup from table Customer.
DDL & DML
2 Likes
Answer
ALTER TABLE Customer
DROP COLUMN CustomerIncomeGroup ;
Answered By
1 Like
Related Questions
Add one more column CustomerIncomeGroup of datatype VARCHAR(10).
Insert few records with relevant information, in the table.
Create table Department as per following Table Instance Chart.
Column Name DeptID DeptName Key Type Primary Nulls/Unique NOT NULL Datatype NUMBER VARCHAR Length 2 20 Create table Employee as per following Table Instance Chart.
Column Name EmpID EmpName EmpAddress EmpPhone EmpSal DeptID Key Type Primary Foreign Nulls/Unique NOT NULL Fk Table Department Fk Column Dept_ID Datatype NUMBER VARCHAR VARCHAR VARCHAR NUMBER VARCHAR Length 6 20 30 10 9, 2 2