How to get all table names of a particular database using TSQL
By FoxLearn 2/16/2024 4:51:23 AM 300
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 fix 'The specified sa password does not meet strong password requirements'
- How to Set Up Dark Theme in SQL Server Management Studio
- DBCC CHECKIDENT RESEED 0
- How to drop temporary table if exists
- How to convert timestamp to date in SQL Server
- How to convert SQL Server's timestamp column to datetime format
- How to convert varchar to uniqueidentifier in SQL Server
- How to Read Excel file and Import data from Excel to SQL Server in C#
Categories
Popular Posts
11 Things You Didn't Know About Cloudflare
12/19/2024