Quackit Logo
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

FREE Hosting!

With every domain name you register with ZappyHost, you get FREE hosting.

$1.99 Domain Names

With every new non-domain purchase thru ZappyHost, you get a domain name for only $1.99.

SQL Alter Table

Print Version

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

Enjoy this website?

  1. Link to this page (copy/paste into your own website or blog):
  2. Add this page to your favorite social bookmarks sites:
               
  3. Add this page to your Favorites

Oh, and thank you for supporting Quackit!

Need Content for your Website?

Get unique, quality digital content for your website. You can even earn money by reselling it!

Includes:

  • Over 29,000 Ebooks
  • Over 7,000 Website templates
  • Over 11,000 Fonts
  • Over 39,000 Logos
  • Over 1,000 Cell Phone Games
  • Over 3,000 Cell Phone Images
  • Over 21,000 Ring Tones
  • ...and much more!
Get your 10GB webmaster package now!