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

Write the SQL query to drop, truncate and delete table.

1026

Tell me what is the difference between locking and multi-versioning?

1082

Can an entity have two primary keys?

1030

How to transfer a table from one schema to another?

1045

What is buffer cash and log cache in sql server?

1183

How to select some specific columns from a table in a query in ms sql server?

1044

What is sql service broker?

1020

What do you mean by 'normalization'?

1121

what is the system function to get current user's user id? : Sql server database administration

1046

What is difference between group by and having?

990

How to change the ownership of a schema in ms sql server?

1255

How to create user defined functions with parameters?

1293

What is use of dbcc commands?

1121

What are the different types of collation sensitivity?

1174

What is the tcp/ip port on which sql server runs?

1235