查询某个mssql server中数据库的详细信息

1.查询sqlserver中所有数据库

select [name] from [sysdatabases] order by [name]

2.查询某个数据库中的所有表

select [id], [name] from [sysobjects] where [type] = 'u' order by [name]

3.查询某表中的所有字段

select [name] from [syscolumns] where [id] = 21575 order by [colid]

4.查询某数据库中的所有触发器

select * from sysobjects where xtype='TR'

触发器位置：select object_name(parent_obj) from sysobjects where id=object_id('trigger_name')

5.查询某数据库中的所有存储过程

select * from sysobjects where xtype='P'

或

select * from sysobjects where type='P'