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 is a transactions?

797


What stored by the master? : sql server database administration

789


What is b tree index?

691


What types of Joins are possible with Sql Server?

817


How many levels of sp nesting is possible?

819


How to include text values in sql statements?

793


How to add code to the existing article (using improve article)?

839


How to create a testing table with test data in ms sql server?

773


where the connection string store in the database

1765


Do I need a report server to run reports in my application?

130


how can u get last observation in an unknown dataset ?

2212


What is left outer join in sql server joins?

721


Explain datetime2 data type in sal server 2008?

727


Difference between group by clause and having clause in SQL?

766


how to create a scrollable cursor with the scroll option? : Sql server database administration

806