How to get all table names of a particular database using TSQL
By FoxLearn 2/16/2024 4:51:23 AM 396
This example shows you the best way to get the names of all of the tables in a specific database on SQL Server or My SQL
Open the SQL editor, and type this query
For SQL Server:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YourDatabaseName'
For MySQL:
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA='YourDatabaseName'
You can use the following query to select all of the tables in the database named DbName
USE DbName SELECT * FROM sys.Tables
Update for the latest version of MSSQL Server 17.7
USE DbName SELECT name FROM sys.Tables WHERE type_desc = 'USER_TABLE'
- How to Download and Restore Northwind database to SQL Server
- How to set time to 00:00:00 with GETDATE() in SQL
- Restoring MySQL Databases with mysqldump
- How to use Oracle linked server shows all tables
- Download backup of Northwind database for SQL Server
- How to Convert varchar to uniqueidentifier in SQL Server
- How to fix 'The transaction log for the database is full due to ACTIVE_TRANSACTION'
- How to use ROW_NUMBER Function in SQL Server
Categories
Popular Posts
Stisla Admin Dashboard Template
11/18/2024
Admin Tailwind CSS Admin Dashboard Template
11/18/2024
Portal HTML Bootstrap
11/14/2024