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 are key, name and value columns of an attribute? : sql server analysis services, ssas
What is the difference between TRUNCATE and DROP?
Why I can not enter 0.001 second in date and time literals in ms sql server?
How to create a simple user defined function in ms sql server?
What are the underflow and overflow behaviors on float literals?
What is merge statement?
How to enter unicode character string literals in ms sql server?
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?
Do you know what are different types of replication in sql server?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is compression - row-level and page-level compression?
What is the difference in accessing db between sql server vs sql azure?
What is sql server agent and what are the two modes of authentication in sql server?
what is raid? : Sql server database administration
How to define the name and server for a new dsn?