知道了,很简单。不知道,搞死你。
一、查询
select column_default from INFORMATION_SCHEMA.columns where table_name='<table name>' and column_name='<column name>'
SELECT object_name(cdefault) FROM syscolumns WHERE id = object_id('<table name>') AND name = '<column name>'
--EXEC sp_depends <table name>
EXEC sp_help <table name>
二、去除
ALTER TABLE <table name> DROP CONSTRAINT <constraint name>
Example:
DECLARE @default sysname
SELECT @default = object_name(cdefault) FROM syscolumns
WHERE id = object_id('<table name>')
AND name = '<column name>'
EXEC ('ALTER TABLE <table name> DROP CONSTRAINT ' + @default)
-----------------------另--------------------
解除: EXEC sp_unbindefault '<table name>.<column name>'
删除:DROP DEFAULT <oject name>
三、加上
ALTER TABLE <table name>
ADD CONSTRAINT <constraint name> DEFAULT <default value> FOR <column name>
绑定:EXEC sp_bindefault '<oject name>, '<table name>.<column name>'
tag:SQL2000, column, default, CONSTRAINT,列,字段,默认值,约束,syscolumns,sysobjects,
-----------------------另--------------------
创建:CREATE DEFAULT oject name AS constant_expression