SQL ALTER TABLE Statement

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

Once a table is created in the database, there are many occasions where one may wish to change the structure of the table. In general, the SQL syntax for ALTER TABLE is,

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:

• Add Column


• Modify Column


• Rename Column


• Drop Column


• Add Index


• Drop Index


• Add Constraint


• Drop Constraint

For all cases, examples are provided for MySQL, Oracle, and SQL Server.

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

About Mariano

I'm Ethan Mariano a software engineer by profession and reader/writter by passion.I have good understanding and knowledge of AngularJS, Database, javascript, web development, digital marketing and exploring other technologies related to Software development.