34,575
社区成员
发帖
与我相关
我的任务
分享
把你做默认值的约束名称drop掉!
if object_id('a') is not null
drop table a
create table a
(
sid varchar(10) default('000'),
sname varchar(10)
)
insert a
select '001','aaa' union all
select '002','bbb' union all
select '003','ccc'
insert into a(sname) values ('ddd')
select * from a
alter table a drop column sid
---会提示约束存在不能删掉
alter table a
drop CONSTRAINT DF__a__sid__6ECB5E34
----把约束去掉
alter table a alter column sid char(10)
SELECT NAME FROM SYSOBJECTS WHERE
ID=(SELECT PARENT_OBJ FROM SYSOBJECTS WHERE ID=OBJECT_ID('D_RealNumber'))