List Schema Name and Table Name for Database

SQL Server: List schema name and table name

Select quotename(SCHEMA_NAME(SCHEMA_ID)) + '.' + QUOTENAME(name)
AS SchemaTable
From sys.tables