This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools).
All SQL
copyraw
-- Add a column to an existing table (giving it datatype char(2) and allowing NULL) ALTER TABLE myTable ADD myColumn CHAR(2) NULL -- Delete a column ALTER TABLE myTable DROP COLUMN myColumn -- Reorder a column ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;
- -- Add a column to an existing table (giving it datatype char(2) and allowing null)
- ALTER TABLE myTable ADD myColumn CHAR(2) NULL
- -- Delete a column
- ALTER TABLE myTable DROP COLUMN myColumn
- -- Reorder a column
- ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;
MySQL and Oracle PL/SQL
copyraw
ALTER TABLE myTable MODIFY myColumn myDataType
- ALTER TABLE myTable
- MODIFY myColumn myDataType
Microsoft Transact SQL (T-SQL)
copyraw
ALTER TABLE myTable ALTER COLUMN myColumn myDataType
- ALTER TABLE myTable
- ALTER COLUMN myColumn myDataType
Category: Databases :: Article: 514
