What is the best way to get the names of all of the tables in a specific database on SQL Server?

Find all tables containing column with specified name Asked 14 years, 10 months ago Modified 6 months ago Viewed 4.5m times

I am looking for T-SQL code to list all tables in all databases in SQL Server (at least in SS2005 and SS2008; would be nice to also apply to SS2000). The catch, however, is that I would like a single

Oct 12, 2010 · SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' But it is giving table names of all databases of a particular server but I …

Feb 8, 2010 · I am searching for a SQL Script that can be used to determine if there is any data (i.e. row count) in any of the tables of a given database. The idea is to re-incarnate the database in case there ...

Mar 27, 2014 · How can I display a list containing all the tables of all the database in a SQL Server 2008 R2 server?

Dec 23, 2014 · This is a hidden Stored Procedure in sql server, and will be executed for each table in the database you're connected. Note: You may need to execute the query a few times to delete all …

Oct 25, 2011 · Possible duplicate of How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?

Oct 1, 2008 · I am not interested in rebuilding the entire database- just simply "re-setting" the data. What is the best way to remove all the data from all the tables using TSQL? Are there system stored …

Sep 18, 2009 · To get that information in SQL Management Studio, right-click on the database name, then select Reports --> Standard Reports --> Disk Usage by Table. This quickly generates a sortable …