List all tables in Database

[deepthiv]

hi,

can anyone please tell wht's the query to check if database exists, if exists list all tables in database (in sqlserver) else raise error

Thanks in advance,
Deepthi

 

[WayneRyan]

Deep,

For SQL Server, this gives you all databases:

Select Name from master..Sysdatabases order by name

Then, this will give you all tables:

Select Name From SomeDatabase..SysObjects Where Type = 'U'

Wayne

 

[deepthiv]

Thanks a lot Ryan..

It helped me