导航

[SQL]查询表里的字段名

Posted on 2015-11-24 14:03  beeone  阅读(671)  评论(0)  编辑  收藏  举报 
Select Name from syscolumns Where ID=OBJECT_ID('表名')
select * from information_schema.tables WHERE TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW'
select * from information_schema.views
select * from information_schema.columns