Results 1 to 2 of 2

Thread: views vows....

  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: views vows....

    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.

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi,

    There is a typo!

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

    Regards,
    Shriyan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •