drop table t create table t ( id int ) ALTER TABLE t Add ColumnName int nullALTER TABLE t ADD CONSTRAINT AddDateDflt1 DEFAULT (0) FOR ColumnNameDROP DEFAULT AddDateDflt1ALTER TABLE t NOCHECK CONSTRAINT AddDateDflt1ALTER TABLE t Drop Column ColumnName 我试了一下,好像不行!
嘿嘿,用小黑的可以了 drop table t create table t ( id int ) ALTER TABLE t Add ColumnName2 int nullALTER TABLE t ADD CONSTRAINT AddDateDflt1 DEFAULT (0) FOR ColumnName2 alter table t DROP CONSTRAINT AddDateDflt1ALTER TABLE t Drop Column ColumnName2
create table t
(
id int
)
ALTER TABLE t Add ColumnName int nullALTER TABLE t ADD CONSTRAINT AddDateDflt1 DEFAULT (0) FOR ColumnNameDROP DEFAULT AddDateDflt1ALTER TABLE t NOCHECK CONSTRAINT AddDateDflt1ALTER TABLE t Drop Column ColumnName
我试了一下,好像不行!
drop table t
create table t
(
id int
)
ALTER TABLE t Add ColumnName2 int nullALTER TABLE t ADD CONSTRAINT AddDateDflt1 DEFAULT (0) FOR ColumnName2 alter table t DROP CONSTRAINT AddDateDflt1ALTER TABLE t Drop Column ColumnName2