List of all tables in a database

SQL Server

 

Famous database from Microsoft. Skyvia requires the server to be available from Internet.

The best way to get the names of all of the tables in a specific database on SQL Server

Query Text

SELECT * 
 FROM 
    information_schema.tables
 ORDER BY
    TABLE_SCHEMA, TABLE_NAME
  

Open Query