Dropping Columns
To drop a column from a table, use an ALTER TABLE statement.
ALTER TABLE Faculty
DROP Rsch_Grant_Amount#
This example drops the Rsch_Grant_Amount column from the Faculty table and deletes the column definition from the data dictionary.
For more information about the ALTER TABLE statement, see the following topic in
SQL Engine Reference
:
ALTER TABLE
.
Note:
Be aware that if you use the ALTER TABLE statement on files that contain a lot of data, execution could take some time to complete, and other users may not be able to access data in that file in the meantime.
Note: Be aware that if you use the ALTER TABLE statement on files that contain a lot of data, execution could take some time to complete, and other users may not be able to access data in that file in the meantime.