Friday, 26 February 2016
DRCAT
D – Drop (To delete a database or table)
R – Rename (To change the column name)
C – Create (To create a database or table)
A – Alter (To work on columns)
T – Truncate(To clear entire table data)
Alter contains three commands:
Alter Add (To add column)
Alter alter (To modify data type of column)
Alter drop (To delete a column)
