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:
  • can i hide a particular table name of our schema.


  • Once a table is created it cannot be moved to a different file group.


  • Which SQL statement is used to delete data from a database?


  • Which SQL statement is used to update data in a database


  • Whats the difference between COUNT(*) and COUNT(ALL expression)?


    		•

    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