sql server 2008
查看所有的表:
select * from information_schema.tables
查看所有的视图:select * from information_schema.views
查看所有的列:
select * from information_schema.columns