DECLARE @TABLE nvarchar(255) SET @TABLE = 'table'; --請改要查詢的資料表名稱
DECLARE @SQL nvarchar(1000) SET @SQL = '
sp_help ' + @TABLE + ';' +
'SELECT * FROM ::fn_listextendedproperty(default, ''user'', ''dbo'', ''table'', ''' + @TABLE + ''', ''column'', NULL);';
EXEC sp_executesql @SQL;
DECLARE @SQL nvarchar(1000) SET @SQL = '
sp_help ' + @TABLE + ';' +
'SELECT * FROM ::fn_listextendedproperty(default, ''user'', ''dbo'', ''table'', ''' + @TABLE + ''', ''column'', NULL);';
EXEC sp_executesql @SQL;
留言
張貼留言