Select all tables in a database

[sridhar21]

hi to all


i am sridhar


My question is:

To select all tables in a database is

select name from sysobjects where type='U'

But want to mension the database name in the query itself


select .............. where database = 'mydatabas'"

i need query for this


thanks

[Purple]

Hi,

how about

SELECT     name AS Expr1, xtype AS Expr2
FROM         mydatabas.dbo.sysobjects
WHERE     (xtype = 'U')

xtype of 'S' if you want system tables

dbo is the owner

Purple