select rtrim(b.name) as colname
,case when h.id is not null then 'PK' else '' end as primarykey
,type_name(b.xusertype) + case when b.colstat & 1 = 1 then '[ID(' + convert(varchar,ident_seed(a.name)) + ',' + convert(varchar,ident_incr(a.name)) + ')]' else '' end as type
,b.length
,case b.isnullable when 0 then 'N' else 'Y' end as [isnull]
,isnull(e.text,'') as [default]
,isnull(c.value,'') as descript
from sysobjects a,syscolumns b
left outer join sysproperties c on b.id = c.id and b.colid = c.smallid
left outer join syscomments e on b.cdefault = e.id
left outer join (select g.id,g.colid from sysindexes f,sysindexkeys g where f.id = g.id and f.indid = g.indid and f.indid > 0 and f.indid < 255 and (f.status & 2048)<>0) h on b.id = h.id and b.colid = h.colid
where a.id = b.id
and a.id = object_id('titles') --tablename改成你要导出的表的名称
order by b.colid
解决方案 »
- sql日期转换问题
- 如何根据条件删除表中重复记录?
- 怎样select获取列名
- sql2005无法通过电子邮件通知"xxx"
- 这个结果怎么筛?
- 求sql两表合并方法@@@@@@@
- 我现在有两个SQL server的数据库,本地数据库A库和远程数据B库!现在我的A类中做了一个触发器,只有插入新的数据,就向 远程数据库 B库的
- 怎样在ORACLE里写一个存储过程可以返回一个查询结果集?
- 紧急求援:SqlServer 2000企业版 未知错误:8007007F
- 关于FOX2.6的一点小问题,望各位高手指点
- 如何翻译下面的几句话?谢谢了。
- 最近得到一个Microsoft Project Server 2002试用版,在安装时提示使用SQLSERVER用户创建数据库,输入用户名和密码后总是提示没有SECURITY
FROM syscolumns INNER JOIN
sysobjects ON syscolumns.id = sysobjects.id
WHERE (sysobjects.name = '表名')
exec sp_columns 'yourtable'orselect A.name col from syscolumns A,sysobjects B where A.id=B.id and B.name='yourtable'