It is possible to make changes after the creation of a table. Here is the structure for making modification in SQL table;
ALTER TABLE "table_name"
[alter specification]
[alter specification] is dependent on the type of alteration we wish to perform. We list a number of common changes below:
[alter specification]
[alter specification] is dependent on the type of alteration we wish to perform. We list a number of common changes below:
Specifications related to modifications are reliant on the action which is asked to be performed. Here are some of the ways of making change in the table;
• ALTER TABLE Add Index
• ALTER TABLE Drop Index
• ALTER TABLE Add Constraint
• ALTER TABLE Drop Constraint
• ALTER TABLE Add Column
• ALTER TABLE Modify Column
• ALTER TABLE Rename Column
• ALTER TABLE Drop Column
• ALTER TABLE Drop Index
• ALTER TABLE Add Constraint
• ALTER TABLE Drop Constraint
• ALTER TABLE Add Column
• ALTER TABLE Modify Column
• ALTER TABLE Rename Column
• ALTER TABLE Drop Column
Leave a Reply