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

Oct 12, 2010 · I am working on application which can deal with multiple database servers like "MySQL" and "MS SQL Server". I want to get tables' names of a particular database using a …

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 …

Sep 29, 2008 · Use the query below to get all the databases: select * from sys.databases If you need only the user-defined databases; select * from sys.databases WHERE name NOT IN …

For all Views, this lists the table name, column name, data type, and length of every column returned by the view. This doesn't answer the question but it is a neat query.

SELECT * FROM userlogin.Tables; and SELECT * FROM userlogin.Company.Tables;, but none of them works. I have seen quite a few posts which suggests using show databases and show …

May 10, 2009 · Is there a SQL command that will list all the tables in a database and which is provider independent (works on MSSQLServer, Oracle, MySQL)?

What query can return the names of all the stored procedures in a SQL Server database If the query could exclude system stored procedures, that would be even more helpful.

How do I query an Oracle database to display the names of all tables in it?

Jan 21, 2015 · 15 SQL Server 2005, 2008, 2012 or 2014: SELECT * FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA = …