getAllTableNamesWithSchema.sql

USE <DBNAME>;

SELECT s.NAME + '.' + t.NAME AS TableName
FROM sys.TABLES t
INNER JOIN sys.schemas s
    ON t.schema_id = s.schema_id ORDER BY TableName