Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Sql Server Views

Interview Question :: Sql Server 7.0

What is the command by which we can see all the tables in a database. I mean, how can we view what tables a database contains?

Answers to "Sql Server 7.0"

RE: Sql Server 7.0?
u have to use the following query Select name from sysobjects where xtype='U' this is for user tables not for system tables if u want system tables also then use Select name from sysobjects
Vote for this answer ::

RE: Sql Server 7.0?
select * from tab;
Vote for this answer ::

RE: Sql Server 7.0?
Didn't you just ask this? While you wait for an answer here - go and read the manual, the help files, and search the internet.
Vote for this answer ::

RE: Sql Server 7.0?
http://www.microsoft.com/technet/prodtec... http://www.sql-server-performance.com/mi... http://www.sql-server-performance.com/tr... http://www.sql-server1.org/group-3729-52...
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License