declare @tb varchar(20) set @tb='MyTable'declare @sql varchar(8000) set @sql='SELECT * FROM '+@tb exec (@sql)
CREATE TABLE #TEMP ( NAME VARCHAR(100), TYPE_DESC VARCHAR(100) )INSERT INTO #TEMP SELECT name,type_desc FROM sys.objects WHERE parent_object_id=OBJECT_ID('表名')INSERT INTO #TEMP SELECT name,type_desc FROM sys.indexes WHERE OBJECT_ID=OBJECT_ID('表名') AND name IS NOT NULL select * from #temp
set @tb='MyTable'declare @sql varchar(8000)
set @sql='SELECT * FROM '+@tb
exec (@sql)
(
NAME VARCHAR(100),
TYPE_DESC VARCHAR(100)
)INSERT INTO #TEMP
SELECT name,type_desc FROM sys.objects WHERE parent_object_id=OBJECT_ID('表名')INSERT INTO #TEMP
SELECT name,type_desc FROM sys.indexes WHERE OBJECT_ID=OBJECT_ID('表名')
AND name IS NOT NULL
select * from #temp