i was just wondering is it possible to have views on tables in another database? i tried this query on database A when i was in database B:

select * from databaseA.table_name

both databases are on same database server. but the error that i get is that unable to locate table : databaseA.table_name

am i making some mistake while entering this query. cuz if i cant run this query i guess i wont even be able 2 have a view on a table in different database.

Hi,

There is a typo!

Query would look like:
select * from databaseA:table_name ;

Regards,
Shriyan