如何使用T-SQL列出SQL Server中的所有表名？

SELECT name FROM sys.databases  -- this can list all database name in the server


user database
SELECT * FROM INFORMATION_SCHEMA.TABLES  
     -- these two line can list the table for one particular database 
SELECT name FROM sys.databases  -- this can lis