ref : http://databases.aspfaq.com/schema-tutorials/schema-how-do-i-show-the-tables-in-a-database.html
--EXEC sp_tables --包括系统表 用户表 视图
SELECT* FROM information_schema.tables where TABLE_TYPE = 'BASE TABLE' ;
/*
SELECT
Owner = TABLE_SCHEMA,
TableName = TABLE_NAME
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE'
AND OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'IsMsShipped') = 0
ORDER BY
TABLE_SCHEMA,
TABLE_NAME
*/
SELECT* FROM information_schema.tables where TABLE_TYPE = 'BASE TABLE' ;
/*
SELECT
Owner = TABLE_SCHEMA,
TableName = TABLE_NAME
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE'
AND OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'IsMsShipped') = 0
ORDER BY
TABLE_SCHEMA,
TABLE_NAME
*/