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
原文：http://www.cnblogs.com/beeone/p/4991432.html