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
What is a transactions?
What stored by the master? : sql server database administration
What is b tree index?
What types of Joins are possible with Sql Server?
How many levels of sp nesting is possible?
How to include text values in sql statements?
How to add code to the existing article (using improve article)?
How to create a testing table with test data in ms sql server?
where the connection string store in the database
Do I need a report server to run reports in my application?
how can u get last observation in an unknown dataset ?
What is left outer join in sql server joins?
Explain datetime2 data type in sal server 2008?
Difference between group by clause and having clause in SQL?
how to create a scrollable cursor with the scroll option? : Sql server database administration