SQL List All Tables In Database
Return all tables in a SQL Server database by querying sys.tables.
1 min read#SQL
This query returns all tables in a particular database.
sql
USE YourDBName
GO
SELECT *
FROM sys.tables
Return all tables in a SQL Server database by querying sys.tables.
This query returns all tables in a particular database.
USE YourDBName
GO
SELECT *
FROM sys.tables