How do I list the available tables in a database I'm
querying?
- 4 Answers
- 6514 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjeev kumar
First Method:
select table_name from information_schema.tables
Second Method:
Select Name from sysobjects where xtype='u'
Note: here 'u' means user created
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between uniqe index and uniqe constraint?
What is pessimistic concurrency?
What is self contained multi valued query?
How to list all schemas in a database?
Mention the differences between local and global temporary tables.
What are the different types of locks in the database?
How to delete a login name in ms sql server?
Explain following error properties?
What is best institute to Learn DotNET And SQL in chennai?
what are the new features introduced in sql server 2000? : Sql server database administration
explain how to create a new schema in a database? : Sql server database administration
How do you delete duplicate records in sql server?
Explain temporary table vs table variable by using cursor alternative?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Why I am getting this error when renaming a database in ms sql server?
