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

What do you understand by a stored procedure?

1051

How to set a database state to offline in ms sql server?

976

Explain optimistic and pessimistic concurrency?

944

How to create a view using data from another view?

912

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

946

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

116

Can two different columns be merged into single column? Show practically?

1021

Explain the disadvantages/limitation of the cursor?

919

What is meant by indexing files?

993

Do you know what are acid properties of transaction?

918

List out different types of normalizations in sql server and explain each of them?

895

What is Command line parameters in PLSQL.?

1074

Sql server reporting services vs. Crystal reports.

122

How to execute stored procedure in select statement sql server?

993

how to create “alternate row colour”?

144