command to display total tables from database

[subbu sk]

Hai All, i am new to sql server2000, i just want to know about the Querry to display all the tables from one database(ex:Master) Thanks in Advance

Thanks Subbu.

[Pete OHanlon]

seelct * from systables

Deja View - the feeling that you've seen this post before.

[subbu sk]

hai , Thanks to u for immediate response, but i want the querry in sqlserver2000 not in oracle. so pls send the querry.

Thanks Subbu.

[ganeshMohan]

sp_tables which returns all tables in the database including system tables select * from sysobjects where xtype='U' which is also returns tables

[Venkataramuc]

select * from sysobjects where xtype='u' regards venkataramu c venkat