查询数据库中所有的表和数据库架构

select * from sys.tablesSELECT distinct TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNSSELECT * FROM INFORMATION_SCHEMA.COLUMNS

转载于:https://www.cnblogs.com/hongjiumu/archive/2013/04/06/3003128.html