mysql查询整个表语句_查询整个数据库的sql语句

1.Oracle：

select table_name

from  user_tab_columns

where COLUMN_NAME= ‘SAL’—查询数据库内所有包含sal列的表名

2.SqlServer

select table_name

from INFORMATION_SCHEMA.COLUMNS

where COLUMN_NAME= ‘ksmc’

INTERSECT

select  b.name

from    sysindexes a ,

sysobjects b

where  a.id = b.id

and a.indid < 2

and a.rowcnt > 0

and objectproperty(b.id, ‘IsMSShipped’) = 0——-查询数据库内包含某个列名，并且存在数据的表名

从整个数据库内查询含有某个字符串的表名(工作量极大，慎用)

declare @cloumns varchar(40)

declare @tablename varchar(40)

declare @str varchar(40)

declare @counts int

declare @sql nvarchar(2000)

declare MyCursor Cursor For

Select a.name as Columns, b.name as TableName from syscolumns a,sysobjects b,systypes c

where a.id = b.id

and b.type &