--表信息
Select a.id as ID, c.name as 表名, a.name as 列名 ,b.name as 类型,
a.length as 长度, a.scale as Scale, a.isnullable as 允许空
from syscolumns a, systypes b, sysObjects c
where a.xtype = b.xusertype and a.id = c.id
and c.xtype='U' and c.status>0
order by c.name,a.colorder
Select a.id as ID, c.name as 表名, a.name as 列名 ,b.name as 类型,
a.length as 长度, a.scale as Scale, a.isnullable as 允许空
from syscolumns a, systypes b, sysObjects c
where a.xtype = b.xusertype and a.id = c.id
and c.xtype='U' and c.status>0
order by c.name,a.colorder
解决方案 »
- 能否通用因特网来设置ODBC连接SQL Server 2000?
- 怎样实现把2个大数据量的UserInfo合并在一个新的Table中?
- Sql server 2000 数据库下载问题
- eclipse中连接mysql数据库出现1045错误,不会改!!
- SQL Server2000里哪个函数是把字符型转换为整型的
- 事务过程中作checkpoint写数据到哪里?文件组中数据是同时写到几个文件中?那么备份时如何选择备份哪些文件 ?
- 怪事天天有!SQL SERVER 2000极限编程,有兴趣的进来瞧瞧!(在线)
- 求怎样用一sql替代2层游标
- 如何在某个表的记录改变时及时发信息?
- 求一个过滤数据的SQL
- 关于一个数据替换问题(2)
- 数据库的日志太大了,怎么让他变小点?
from sysobjects a join syscolumns b on a.id=b.id
where a.xtype='U' and a.status>=0 and a.name = '表名' --输入你的表名
Where table_name=表名
where id = object_id('表名')
FROM syscolumns
where id=object_id('表名')