Sql查询数据库名,表名,存储过程,表字段名

 select name from master..sysdatabases where dbid>4          //查询数据库

select name,crdate from sysobjects where xtype='P' order by name    //查询存储过程

select name,crdate from sysobjects where xtype='U' order by name    //查询用户表

SELECT syscolumns.name as 列名,systypes.name as 数据类型,syscolumns.isnullable as 是否

空,syscolumns.length as 字符长度 FROM syscolumns, systypes WHERE

syscolumns.xusertype=systypes.xusertype AND syscolumns.id = object_id('你的表名') //查询表结构