--如果是sql 2000的话SELECT OBJECT_NAME(id) AS '表名',name AS '列名' FROM syscolumns WHERE name ='model'
SELECT OBJECT_NAME(id) AS '表名',name AS '列名' FROM syscolumns WHERE name ='l1'
SQLServer2000 ---------- select tab.name,col.name from syscolumns col, sysobjects tab where col.id=tab.id
select sysobjects.name as tablename,syscolumns.name as columnname from syscolumns join sysobjects on sysobjects.id = syscolumns.id where syscolumns.name like '%此处为列名%'
对象名 'sys.columns' 无效。
比如数据库名称是l1.实际案例语句应该怎样写呢
--如果是sql 2000的话SELECT OBJECT_NAME(id) AS '表名',name AS '列名' FROM syscolumns WHERE name ='model'
----------
select tab.name,col.name
from syscolumns col,
sysobjects tab
where col.id=tab.id
from syscolumns join sysobjects on sysobjects.id = syscolumns.id
where syscolumns.name like '%此处为列名%'