sp_mshelpcolumns student如上可以看到该表的所有结构、约束、默认值等
select * from sysobjects where parent_obj in(select id from sysobjects where name='student')
exec sp_helpconstraint @objname= 表名
