摘要:T-SQL list of all tables in SQL server
select TABLE_NAME from information_schema.tables where Table_Type = 'BASE TABLE'
select * from information_schema.COLUMNS
select * from information_schema.KEY_COLUMN_USAGE
select * from information_schema.TABLE_CONSTRAINTS