How do I list the available tables in a database I'm
querying?
- 4 Answers
- 6247 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
Why truncate is ddl command?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How can we get count of the number of records in a table?
How you can move data or databases between servers and databases in sql server?
What is the security principal at the database level that represents your session?
Explain alternate key, candidate key and composite key in sql server?
Can We Use Data-grids For Our Report In Ssrs?
Why variables called the most powerful component of ssis?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Do you know the capabilities of cursors?
Do you know nested transaction?
What is subquery explain with example?
Tell me in brief how sql server enhances scalability of the database system?
Can we join two tables without primary key?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
