SQL Query: how to search for table name's in a SQL database server?

Question

currently i'm new to my job, whereby i can't search for any tables name in the database, so is there any SQL qurey or software, where able to let me view the database tables name?

Answer 1

It depends on the type of server. AS400 has the names of all the objects stored on the server in the SYSCAT. I think oracle is similar. I'm not sure about Microsoft but I'd image it's similar. I cant remember the name of the exact table.



I know you can use query tool to show all the tables in a collection.



www.querytool.com



It's a pretty solid (and cheap) Sql program. It also has a long trial period.

Answer 2

In SQL Server, run the dbo.sp_tables stored procedure on the database. (That's an internal/system stored procedure.)



What type of access do you have in the DB? Can you use the Query Analyzer?

Answer 3

you have 4 extremely some issues you choose to keep on your database: substantial classification Sub classification Minute Sub classification classification so which you like 4 columns. One for each. do no longer attempt to get clever and encode the 1st 3 columns in one integer container. you will pass nuts attempting to interrupt the only selection into the three factors. start up with 4 columns.

Answer 4

What are you using the manage the database(s)?

Answer 5

use phpmyadmin. its very useful it will sort columns and tables, and its easy to use. it can order tables by how old they are, alphabetical order, size etc

Answer 6

select table_name from information_schema.tables

Answer 7

What DBMS?