--取列名
select
b.name
from
sysobjects a,
syscolumns b
where
a.id=b.id
and
a.name='TableName'
and
a.type='U'
--取表或视图 名
SELECT name FROM sysobjects WHERE type = 'u' or type = 'v'
--取列名
select
b.name
from
sysobjects a,
syscolumns b
where
a.id=b.id
and
a.name='TableName'
and
a.type='U'
--取表或视图 名
SELECT name FROM sysobjects WHERE type = 'u' or type = 'v'
转载于:https://www.cnblogs.com/scorpioyyy/archive/2008/10/29/1322013.html