主键:
select B.name tablename, A.name pk_name from sysobjects as A
left join sysobjects B
on A.parent_obj = B.id where A.xtype = 'pk' and B.name = 'yourname'
select B.name tablename, A.name pk_name from sysobjects as A
left join sysobjects B
on A.parent_obj = B.id where A.xtype = 'pk' and B.name = 'yourname'
select B.name tablename, A.name pk_name from sysobjects as A
left join sysobjects B
on A.parent_obj = B.id where A.xtype = 'tr' and B.name = 'yourname'
select B.name tablename, A.name pk_name from sysobjects as A
left join sysobjects B
on A.parent_obj = B.id where A.xtype = 'c' and B.name = 'yourname'
不是啦,我的意思是说如果如何读取有主键的字段,次键的字段,还有就是有关系的字段,和有约束的字段啊
请你看好题目!不过对你的回答我还是表示感谢!
你的问题好像有点笼统,不够清楚,能否再举一下例,说明你想要的结果。
右键,所有任务,产生SQL脚本
只选你要的表,在选项中选中[索引][主,外等约束]
确定
即可生成带主键,外键,约束的SQL脚本