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

Enjoy this website?

Add this page to your Favorites

Link to this page (copy/paste into your own website or blog):

Link to Quackit using one of these banner ads.

Help support Quackit by making a donation

Oh, and thank you for supporting Quackit!

SQL Home SQL Tutorial Introduction SQL Syntax SQL Select SQL Where SQL Order By SQL Top SQL Distinct SQL In SQL Alias SQL Join SQL Inner Join SQL Outer Join SQL Insert SQL Update SQL Delete SQL Functions SQL Count SQL Create SQL Create Database SQL Create Table SQL Create Index SQL Alter Table SQL Summary
	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 SQL syntax `ALTER TABLE table_name ADD column_name datatype` Example SQL Statement `ALTER TABLE Individual ADD age int` Change the Datatype SQL syntax `ALTER TABLE table_name ALTER COLUMN column_name datatype` Example SQL Statement `ALTER TABLE Individual ALTER COLUMN age numeric` Drop a Column 'Dropping' a column means removing or deleting that column. SQL syntax `ALTER TABLE table_name DROP COLUMN column_name` Example SQL Statement `ALTER TABLE Individual DROP COLUMN age` << Previous Lesson Summary >> Enjoy this website? Share 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 Link to Quackit using one of these banner ads. Help support Quackit by making a donation Oh, and thank you for supporting Quackit!