Interested to Buy Any Domain ? << Click Here >> for more details...
How do I list the available tables in a database I'm
querying?
- 4 Answers
- 7361 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
You can get a list of tables in a database by calling the
INFORMATION_SCHEMA.Tables view like this:
SELECT * FROM information_schema.tables
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain aggregate functions?
How to generate create table script on an existing table in ms sql server?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
How many categories of functions based their return modes?
How do clustered indexes store data?
Explain the steps to use transact-sql cursor?
What is role playing dimension with two examples? : sql server analysis services, ssas
What are the differences between left join and inner join in sql server?
Explain time data type in sal server 2008?
What languages bi uses to achieve the goal?
Where in ms sql server is ’100’ equal to ‘0’?
What are the difference between clustered and a non-clustered index?
How do I find query history in sql server?
Explain the various types of concurrency problem?
How to create nested stored procedure?
