The SQL Procedure: ALTER TABLE Statement. Adds columns to, drops columns from, and changes column attributes in an existing table. Adds, ... the values in the altered column continue to have the index ...

It is also useful if you are running SQL statements from an SQL application in another SQL-based database. The second form uses a LIKE clause to create a table that has the same column names and ...