What is the best way to get the names of all of the tables in a specific database on SQL Server?
Sql-server – How to get list of all tables in a database using TSQL
database-tablesql servertsql
Related Topic
- Sql-server – How to check if a column exists in a SQL Server table
- Sql-server – Check if table exists in SQL Server
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- Sql – How to list all foreign keys referencing a given table in SQL Server
- Sql-server – Altering a column: null to not null
- Sql – How to UPDATE from a SELECT in SQL Server
- Sql-server – Get size of all tables in database
- Sql – How to delete using INNER JOIN with SQL Server
Best Answer
SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017 or 2019:
To show only tables from a particular database
Or,
PS: For SQL Server 2000: