MS SQL基础教程：SQL数据库表的修改

核心提示：| {CHECK | NOCHECK} CONSTRAINT{ALL | constraint_name[,...n]}| {ENABLE | DISABLE} TRIGGER{ALL | trigger_name[,...n]}}<column_definition> ::= { column_name

| {CHECK | NOCHECK} CONSTRAINT

{ALL | constraint_name[,...n]}

| {ENABLE | DISABLE} TRIGGER

{ALL | trigger_name[,...n]}

}

<column_definition> ::= { column_name data_type }

[ [ DEFAULT constant_expression ]

| [ IDENTITY [(seed, increment ) [NOT FOR REPLICATION] ] ]

]

[ ROWGUIDCOL ]

[ COLLATE < collation_name > ]

[ <column_constraint>] [ ...n]

<column_constraint> ::= [CONSTRAINT constraint_name]

{ [ NULL | NOT NULL ]

| [ { PRIMARY KEY | UNIQUE }

[CLUSTERED | NONCLUSTERED]

[WITH FILLFACTOR = fillfactor]

[ON {filegroup | DEFAULT} ] ] ]

| [ [FOREIGN KEY]

REFERENCES ref_table [(ref_column) ]

[ ON DELETE { CASCADE | NO ACTION } ]

[ ON UPDATE { CASCADE | NO ACTION } ]

[NOT FOR REPLICATION ] ]

| CHECK [NOT FOR REPLICATION]

(logical_expression)}

<table_constraint> ::= [CONSTRAINT constraint_name]

{ [ { PRIMARY KEY | UNIQUE }

[ CLUSTERED | NONCLUSTERED]

{ ( column [ ASC | DESC ] [,...n] ) }

[ WITH FILLFACTOR = fillfactor]

[ON {filegroup | DEFAULT} ] ]

| FOREIGN KEY

[(column[,...n])]

REFERENCES ref_table [(ref_column[,...n])]

[NOT FOR REPLICATION]

[ ON DELETE { CASCADE | NO ACTION } ]

[ ON UPDATE { CASCADE | NO ACTION } ]

| CHECK [NOT FOR REPLICATION]