Code Snippet posted by:
Sabarimahesh | Posted on: 4/19/2012 | Category:
SQL Server Codes | Views: 471 | Status:
[Member] |
Points: 40
|
Alert Moderator
ALTER TABLE Syntax
ALTER TABLE table-Name
{
ADD COLUMN column-definition |
ADD CONSTRAINT clause |
DROP { PRIMARY KEY | FOREIGN KEY constraint-name | UNIQUE
constraint-name | CHECK constraint-name | CONSTRAINT constraint-name }
ALTER [ COLUMN ] column-alteration |
LOCKSIZE { ROW | TABLE }
}
Life is a Race
Thanks & Regards
By
Sabari Mahesh P M