//1.根据表名获取表的字段信息(SysColumns存放字段信息):
select * from SysColumns where ID=OBJECT_ID('score') Order By ColID
//2.获取所有表的信息(sysobjects存放该数据库中的表信息)。
select * from sysobjects where xtype='u'
//3.获取所有的存储过程之类的信息(syscomments存放存储过程信息)
select * from syscomments
//4.(systypes表存放数据库的类型信息)
select * from systypes
//5.获取指定表的主键。
select 主键=a.name
FROM syscolumns a
join sysobjects b
on a.id=b.id and b.xtype='U'
and b.name<>'dtproperties'
where exists
(
SELECT 1
FROM sysobjects
where xtype='PK'
and name in
(
SELECT name
FROM sysindexes
WHERE indid
in
(
SELECT indid
FROM sysindexkeys
WHERE id = a.id AND colid=a.colid
)
)
)
and b.name='score'
//以上所有表都是被存放在sqlserver的每个数据库的系统表中,用来记录本数据库的信息。