INTERVIEW QUESTIONS DATABASE SQL SERVER DETAILS

Question : What is the query used to display all tables names in SQL Server (Query analyzer)? Category SQL Server Interview Questions Rating (0.0) By 0 users Added on 4/3/2008 Views 533 Rate it! * * * * * * * * * * * * * * *

Answers: select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE' select * from sysobjects where type='u'  Posted by: Rajaram       Contact Rajaram The above posted query will show only User created table list. Try the above query without WHERE clause  Posted by: Ravi       Contact Ravi If you have the better answer, then send it to us. We will display your answer after the approval. Name :* Email Id :* Answer :* Verification Code  Not readable? Load New Code   Enter the above shown code:* Inform me about updated answers to this question

	Related Questions	View Answer
	What is a dirty page and dirty report?	View Answer
	What are the new enhancements in SQL server 2005?	View Answer
	Difference between a "where" clause and a "having" clause?	View Answer
	Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?	View Answer
	Explain real time situation where you would use clustered and Non-clustered Indexes?	View Answer
	What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it	View Answer
	What are "HINTS"? What is "index covering" of a query?	View Answer
	What are data objects?	View Answer
	What is the difference between User Identification and Authentication?	View Answer
	How to display the table data in XML format using SQL Server.	View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: