select a.name from syscolumns a,sysobjects b where a.id=b.id and b.name='a'
解决方案 »
- 请教一下数据库执行顺序(下列语句的执行过程)
- sql 排列为什么出现次序乱
- 请问如何将Access表生成SQL脚本,然后在SQL Server中查询分析后在把Access表中的数据导入到SQL里啊?
- BULK语句怎么截取数据文件的数据?
- MYSQL调度的问题
- 重键索引的语句
- 求一个多表组合查询SQL语句?(在线)
- 视图查询问题?
- 第一次把sqlserver中的数据导出到access数据库中,出现的问题,不知道该怎样解决,请高手进来帮帮忙
- objconn.execute "update GR_bbs set [restore]=[restore]+'"&res&"' where cstr(ID) ='"&request("parentid")&"'"
- 如何修改JOB的参数?
- 请帮忙
as
select o.name as oname, c.name as cname,convert(varchar(30),p.value) as value,p.smallid as psmallid,t.name as tname
from syscolumns c
join systypes t on c.xtype = t.xtype
join sysobjects o on o.id=c.id
left join sysproperties p on p.smallid=c.colid and p.id=o.id
where o.xtype='U'
,t.name 数据类型
,c.prec as 长度
,p.value as 字段说明
,m.text as 默认值
from syscolumns c
inner join
systypes t
on c.xusertype=t.xusertype
left join
sysproperties p
on c.id=p.id and c.colid = p.smallid
left join
syscomments m
on c.cdefault=m.id
where objectproperty(c.id,'IsUserTable')=1 and c.id=object_id('A表')