Hi,
how do I get a list of all tables (User) and list of views when I am having database name with me

Please let me know

SELECT [name] FROM DBName.dbo.sysobjects WHERE xtype IN ('U', 'V') ORDER BY
xtype, [name]

HTH

Semper Fi,
Red
[quoted text, click to view]

Kishor,

Here are a couple:

use MyDatabase
select * from INFORMATION_SCHEMA.TABLES
select * from INFORMATION_SCHEMA.VIEWS


select [name], *,
case xtype when 'U' then 'Table' else 'View' end
from MyDatabase..sysobjects
where xtype in ( 'U', 'V' )
order by [name]

The 1st method is less flexible, but more likely to survive an upgrade.

Regards
AJ

[quoted text, click to view]