SQL Keywords: COLUMN
|
SQL Keywords: COLUMN |
|
Adding a New Column |
The COLUMN keyword is used to identify a field of a table. The COLUMN keyword can be used to add a new column to an existing table. The formula to use would be:
ALTER TABLE TableName ADD COLUMN ColumnName DataType
|
Removing an Existing Column |
The COLUMN keyword can be used when removing a column from a table in SQL. The formula to use would be:
ALTER TABLE TableName DROP COLUMN ColumnName;
or
ALTER TABLE TableName DROP COLUMN ColumnName
|
|
||
| Home | Copyright © 2005-2016, FunctionX, Inc | |
|
|
||