Simple query To Display only user created table. Select * from sysobj

How do I list the available tables in a database I'm
querying?

Question Posted / kumar.t

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

Please Help Members By Posting Answers For Below Questions

How to connect of datebase with sql express.?

1104

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

945

Define constraints and give an example of their use?

1041

What is index fragmentation in ms sql server?

1085

What is an identity column in insert statements?

1023

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

967

Explain indexes disadvantages?

1086

What is model database? : SQL Server Architecture

1133

Explain what is lock escalation?

1066

What are constraints?

1012

How to create a user to access a database in ms sql server using "create user" statements?

954

What is the purpose of a table?

959

Explain features of analysis services?

1002

How to create a simple table to test triggers in ms sql server?

975

What is a document index?

1028