SQL ALTER Command

ALTER sql command is used to change the table structure. For instance changing

Code:

ALTER TABLE 'Department' CHANGE 'DepName' 'Name' varchar( 50 )  NOT NULL

Also we can used ALTER command to add constrain to a specific column to be UNIQUE :

Code:

ALTER TABLE 'Department' ADD UNIQUE ('Dep_id')

You can also it to add auto increment to a specific table's column

Code:

ALTER TABLE 'Department' CHANGE 'Dep_id' 'Dep_id' INT( 5 ) NOT NULL AUTO_INCREMENT

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : SQL ALTER Command
DDL Statements-Adding Constraints-CREATE-ALTER-TABLE -
Types of Databases and statements, Create, Alter, delete -
BETWEEN SQL COMMAND -
SQL DISTINCT Command -
Average SQL command -
PHP echo command -
SQL COUNT Command -
JVM does not recognize MQ command. -
SQL LIKE query Command -
SQL LOCATE command -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com