How do I list the available tables in a database I'm
querying?
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
How to convert binary strings into integers in ms sql server?
How to include date and time values in sql statements?
What is difference between clustered index and non clustered index?
How can windows applications connect to sql servers via odbc?
What happens if you add a new index to large table?
Explain time data type in sal server 2008?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is DCL?
How to create an index on a view?
What is self contained sub query?
What encryption security is available in sql azure?
How to use subqueries with the exists operators in ms sql server?
How and why use sql server?
Define constraints and give an example of their use?
What is the security principal at the server level that represents your session?