VanillaGranilla icon

getAllTableNamesWithSchema.sql

VanillaGranilla | PRO | 02/27/14 08:19:00 PM UTC | 0 ⭐ | 246 👁️ | Never ⏰ | []
SQL |

150 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
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

Comments