--得到指定表有多少个字段
SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='tablename'
--得到所有用户表名
SELECT OBJECT_NAME (id)
FROM sysobjects
WHERE xtype = 'U' AND OBJECTPROPERTY (id, 'IsMSShipped') = 0
--获得指定表上所有的索引名称
SELECT name FROM sysindexes
WHERE id = OBJECT_ID ('empbas') AND indid > 0
--数据库信息
exec (sp_databases)
SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='tablename'
--得到所有用户表名
SELECT OBJECT_NAME (id)
FROM sysobjects
WHERE xtype = 'U' AND OBJECTPROPERTY (id, 'IsMSShipped') = 0
--获得指定表上所有的索引名称
SELECT name FROM sysindexes
WHERE id = OBJECT_ID ('empbas') AND indid > 0
--数据库信息
exec (sp_databases)