FREE Hosting!
With every domain you register with ZappyHost you get FREE hosting.

SQL Alter Table

In an earlier lesson, we created a table with the CREATE TABLE command. In this lesson, we will modify the table using the ALTER TABLE command.

Add a Column

ALTER TABLE table_name
ADD column_name datatype

ALTER TABLE Individual
ADD age int

ALTER TABLE table_name
ALTER COLUMN column_name datatype

ALTER TABLE Individual
ALTER COLUMN age numeric

'Dropping' a column means removing or deleting that column.

ALTER TABLE table_name
DROP COLUMN column_name


ALTER TABLE Individual
DROP COLUMN age

Add this page to your Favorites
Link to this page (copy/paste into your own website or blog):
<a href="http://www.quackit.com/sql/tutorial/sql_alter_table.cfm">SQL Alter Table</a> from Quackit.com
Help support Quackit by making a donation

Oh, and thank you for supporting Quackit!

Need Website Content?
Get unique, quality digital content for your website.