比如
查ERP数据库中所有表的表名中含2014的表的名称及字段信息 sql脚本
select tab.name,*
from syscolumns as col
inner join sysobjects as tab on col.id = tab.id
where tab.name like '%2014'
比如
查ERP数据库中所有表的表名中含2014的表的名称及字段信息 sql脚本
select tab.name,*
from syscolumns as col
inner join sysobjects as tab on col.id = tab.id
where tab.name like '%2014'