Get all table names of a particular database by SQL query?

by

Probably due to the way different sql dbms deal with schemas.

Try the following

For SQL Server:

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='dbName'

For MySQL:

SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA='dbName'

For Oracle I think the equivalent would be to use DBA_TABLES.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. select yesterday date in where condition
  3. Can I use CASE statement in a JOIN condition?
  4. Import CSV file into SQL Server
  5. How to create a table from select query result in SQL Server 2008 [duplicate]
  6. Are there any disadvantages to always using nvarchar(MAX)?
  7. Creating an index on a table variable
  8. Is there a LastIndexOf in SQL Server?
  9. SQL Server – stop or break execution of a SQL script
  10. What is the difference between using a cross join and putting a comma between the two tables?
  11. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  12. Pivot Table and Concatenate Columns
  13. How do I calculate a running total in SQL without using a cursor?
  14. Equivalent of Oracle’s RowID in SQL Server
  15. Concat field value to string in SQL Server
  16. Months between two dates
  17. Why can’t I use alias in a count(*) “column” and reference it in a having clause?
  18. How to store image in SQL Server database tables column [duplicate]
  19. How to find third or nᵗʰ maximum salary from salary table?
  20. SQL “between” not inclusive
  21. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  22. Benefits Of Using SQL Ordinal Position Notation?
  23. sql group by only rows which are in sequence
  24. SQL Server replace, remove all after certain character
  25. Does UNION ALL guarantee the order of the result set [duplicate]
  26. Inserting rows into a table with one IDENTITY column only [duplicate]
  27. How to find sum of multiple columns in a table in SQL Server 2005?
  28. How to retrieve field names from temporary table (SQL Server 2008)
  29. When using GETDATE() in many places, is it better to use a variable?
  30. What’s the correct name for an “association table” (a many-to-many relationship) [closed]

Leave a Comment