查看表的默认值:
select S.id,C.*
from sysconstraints S
join syscomments C
on S.constid=C.id
where S.id=object_id('tableName') and object_name(s.constid) like '%DF%'根据默认值t_id_d查看:
select * from syscomments S join sysobjects O on O.name like '%t_id_d%' and S.id=O.id
select S.id,C.*
from sysconstraints S
join syscomments C
on S.constid=C.id
where S.id=object_id('tableName') and object_name(s.constid) like '%DF%'根据默认值t_id_d查看:
select * from syscomments S join sysobjects O on O.name like '%t_id_d%' and S.id=O.id
或者可以使用类似 select max(id)+1 from table 的语句?请赐教。