How do I list the available tables in a database I'm
querying?
- 4 Answers
- 6246 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjeev kumar
First Method:
select table_name from information_schema.tables
Second Method:
Select Name from sysobjects where xtype='u'
Note: here 'u' means user created
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how you can deploy an SSRS report?
What is 3nf normalization form?
How do I run a trace in sql server?
between cast and convert which function would you prefer and why?
What the different topologies in which replication can be configured?
What is user defined datatypes and when you should go for them?
How do I create a trace in sql server?
What is difference between stored procedure and user defined function?
Why do you want to join software field as you have done your BE in Electronics?
What is difference between equi join and inner join?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is proper subset of candidate key?
How to delete duplicate rows from table except one?
Can you explain the disadvantages/limitation of the cursor?
What is relationship? What number of sorts of relationship are there?
