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 are the difference between data mart and data warehouse? : sql server analysis services, ssas

500

What are the steps to process a single select statement?

509

Can two tables share a primary key?

514

What happens if date-only values are provided as date and time literals?

540

What are the pre-defined functions in the sql server?

518

Tell me about normalization in DBMS.

576

Explain optimistic and pessimistic concurrency?

539

Does the unique constraint create an index?

564

What is it’s similarity with sql server?

143

What are sql server functions?

512

Does index speed up select statements?

581

What is openrowset sql server?

518

What is the difference between Triggers and Stored Procedure?

567

Find nth lowest salary or get nth lowest salary?

593

How to use “drop” keyword in sql server and give an example?

683