摘要：
--SQL 查询所有表名：SELECT NAME FROM SYSOBJECTS WHERE TYPE='U'SELECT * FROM INFORMATION_SCHEMA.TABLES--查询表的所有字段名：SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('表名' )SELECT * FROM INFORMATION_SCHEMA.TABLESSELECT * FROM INFORMATION_SCHEMA.VIEWSSELECT * FROM INFORMATION_SCHEMA.COLUMNS 分页：--CR 阅读全文
