List of tables

Hi,
Is there any command to find all the tables(including system tables) in SQLserver(I do not want to use enterprise manager).
Regards,Originally posted by sursujmad
Hi,

Is there any command to find all the tables(including system tables) in SQLserver(I do not want to use enterprise manager).

Regards,

You can use a sql request like this

select * from sysobjects where type = 's' or type = 'u'|||--Try
exec sp_tables
select user_name(uid)+'.'+name from sysobjects where xtype in ('U','S')
select * from information_schema.tables