How do I list the available tables in a database I'm
querying?
- 4 Answers
- 6513 Views
- I also Faced
- E-Mail Answers
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 difference between commit and rollback when used in transactions?
List out some of the requirements to set up a sql server failover cluster?
What are trace files?
What is update locks?
What are horizontal and vertical scaling?
Is mysql better than sql server?
How to enter binary string literals in ms sql server?
Do you know what is similarity and difference between truncate and delete in sql?
How to use old values to define new values in update statements in ms sql server?
How to resolve the orphan use problem? : sql server security
What is scrollable cursor?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to apply filtering criteria at group level with the having clause in ms sql server?
What are the advantages of stored procedure in sql server?
What is merge statement?
