快速查询数据库中某个表或字段。。。

--查询所有表名
select name from dbo.sysobjects where xtype='u' and (not name LIKE 'dtproperties') 

--查询所有表的所有字段名
SELECT dbo.sysobjects.name as Table_name, dbo.syscolumns.name AS Column_name 
FROM dbo.syscolumns INNER JOIN 
      dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id 
WHERE(dbo.sysobjects.xtype = 'u') AND (NOT (dbo.sysobjects.name LIKE 'dtproperties')) 

--查询指定表的所有字段名
SELECT dbo.sysobjects.name as Table_name, dbo.syscolumns.name AS Column_name 
FROM dbo.syscolumns INNER JOIN 
      dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id 
WHERE dbo.sysobjects.name='表名'and (dbo.sysobjects.xtype = 'u') AND (NOT (dbo.sysobjects.name LIKE 'dtproperties'))

select * from sysobjects where name like '%bm%' and xtype='U'......查找数据库里面的所有表