select a.name 表名,b.name 列名
from sysobjects a,syscolumns b
where a.id=b.id and OBJECTPROPERTY(a.id, N'IsUserTable') = 1
from sysobjects a,syscolumns b
where a.id=b.id and OBJECTPROPERTY(a.id, N'IsUserTable') = 1
列名:select Column_name from information_schema.columns
sp_help 对表察看所有字段
sp_help 表名
select a.name 表名,b.name 列名
from sysobjects a,syscolumns b
where a.id=b.id and OBJECTPROPERTY(a.id, N'IsUserTable') = 1