1,SELECT name, length
FROM syscolumns
WHERE (id =
(SELECT id
FROM sysobjects
WHERE name = 'YourtableName'))
FROM syscolumns
WHERE (id =
(SELECT id
FROM sysobjects
WHERE name = 'YourtableName'))
解决方案 »
- 请教一条SQL,关于删除的
- winxp系统里 如何安装SQL-SERVER 2000 服务器
- sql 求帮助
- 求助,这样的问题如何解决,在线等后!加分~~~
- create table问题
- 关于Analysis Manager里面的MDX示例无法连接的问题!
- 打不开企业管理器中的"数据库",查询分析器的每个操作都很慢.
- 怎么实现这样的查询结果?
- SQLServer出现死锁,高手进来,绝对送分!
- objconn.execute "update GR_bbs set [restore]=[restore]+'"&res&"' where cstr(ID) ='"&request("parentid")&"'"
- 插入数据库回车换行符的问题,急!!!谢谢!
- 如果让记录的修改和增加时,Update字段自动使用服务器时间?
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
SELECT name, length
FROM syscolumns
WHERE (id = OBJECT_ID('trsnews'))
SELECT name, length
FROM syscolumns
WHERE (id = OBJECT_ID('YourTableName'))