C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...



Posted Date: 30 Oct 2009      Posted By: satya      Member Level: Diamond       Category: SQL Server

Which query we can use to retrieve all the tables in a database?

Select Answer:

SELECT * fROM information_schema.yables
Select name from sysobjects where type='u' order by name
Sp_tables
All the above




      
Your Test Score: 0 / 0



Next Question: What happens when we use update or delete sql command without where clause on a table?
Previous Question: Which function is used to get the current user's user id?
Related Questions:
  • In order to fetch data from database which of the following SQL command is used?


  • With SQL, how do you select a column named "FirstName" from a table named "Persons"?


  • You are designing an inventory and shipping database for Contoso,Ltd. You create the logical database design shown below: You must ensure that the referential integrity of the database is maintained. Which three types of constraints should you apply to your design


  • An automatic commit ocurrs under the following circumstances


  • Who Invented CODD Rule ?


    		•

    Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 
    Java 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers

    About Us    Contact Us    Privacy Policy    Terms Of Use