How do I list the available tables in a database I'm
querying?

Answer Posted / kumar.t

Simple query

To Display only user created table.

Select * from sysobjects where xtype='u'

To Display all table.

Select * from sysobjects

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are key, name and value columns of an attribute? : sql server analysis services, ssas

812


What is the difference between TRUNCATE and DROP?

861


Why I can not enter 0.001 second in date and time literals in ms sql server?

805


How to create a simple user defined function in ms sql server?

795


What are the underflow and overflow behaviors on float literals?

863


What is merge statement?

875


How to enter unicode character string literals in ms sql server?

806


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

751


Do you know what are different types of replication in sql server?

791


What is attribute relationships, why we need it? : sql server analysis services, ssas

756


What is compression - row-level and page-level compression?

731


What is the difference in accessing db between sql server vs sql azure?

168


What is sql server agent and what are the two modes of authentication in sql server?

784


what is raid? : Sql server database administration

776


How to define the name and server for a new dsn?

765