How to Alter Table in Sql?

Sabarimahesh
Posted by Sabarimahesh under Sql Server category on | Points: 40 | Views : 1113
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 }
}

Comments or Responses

Login to post response