How to get all table names of a particular database using TSQL
By FoxLearn 2/16/2024 4:51:23 AM 260
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 Insert Update Delete View and Search data from MySQL in C#
- How to Download and Restore Northwind database to SQL Server
- How to Download ODBC Driver for SQL Server
- Download SQL Server Management Studio (SSMS) Versions
- How to convert varchar to uniqueidentifier in SQL Server
- Connection string mysql
- How to convert string to datetime in SQL
- Download backup of Northwind database for SQL Server
Categories
Popular Posts
Material Lite Admin Template
11/14/2024
Freedash bootstrap lite
11/13/2024
RuangAdmin Template
11/17/2024
Responsive Animated Login Form
11/11/2024