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] is dependent on the type of alteration we wish to perform. We list a number of common changes below:
For all cases, examples are provided for MySQL, Oracle, and SQL Server.
Next: SQL ADD COLUMN
|| Copyright © 2013 1keydata.com All Rights Reserved.