select name from sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1;
解决方案 »
- 哪里可以找到SQL 标准命令
- 如何查看建立的约束(constraint)
- 请问系统存储过程能删除吗(如sp_addlogin,sp_addusr,sp_addsrvrolemember)?
- 如何删除表中的重复记录,只剩下一条?
- 余世维成功经理人讲座免费下载地址: 兄弟们们都值得看看
- 为什么更改sqlserver数据库表中的记录会提示“在流水模式下,事务无法启动”?
- 从未见过的SQL SERVER触发器问题,“死也想不明白”
- 有谁知道如何将Sybase中的数据转换到SqlServer2000中?
- 为什么SELECT语句的VALUES()可以插入数字不能插入字符?
- 请问如何获得表的字段?
- 关于存储一长段文本文字的问题
- 怎样在系统进行insert ,update,delete时不生成日志呢?因为操作量太大
a.colorder 字段序号,
a.name 字段名,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) 标识,
(case when (SELECT count(*)FROM sysobjects WHERE
(name in(SELECT name FROM sysindexes WHERE (id = a.id) AND (indid in(SELECT indid FROM sysindexkeys WHERE (id = a.id) AND
(colid in(SELECT colid FROM syscolumns WHERE (id = a.id) AND (name = a.name))))))) AND(xtype = 'PK'))>0 then '√' else '' end) 主键,
b.name 类型,
a.length 占用字节数,
COLUMNPROPERTY(a.id,a.name,'PRECISION') as 长度,
isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as 小数位数,
(case when a.isnullable=1 then '√'else '' end) 允许空,
isnull(e.text,'') 默认值,
isnull(g.[value],'') AS 字段说明
FROM syscolumns a left join systypes b
on a.xtype=b.xusertype
inner join sysobjects d
on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
left join syscomments e
on a.cdefault=e.id
left join sysproperties g
on a.id=g.id AND a.colid = g.smallid
order by a.id,a.colorder
S:系统表
U:用户表
V:视图
P:存储过程
...
select name from sysobjects where xtype='u'and status>0