Re: create views
Yes, we've done it for some similar tables, works fine
create view whatever (...) as select from dbname:table
brett
Jane Vohden wrote:
>
> Can you create a view in one database that looks at a table(s) in another
> database?
> Thanks. - Jane
>
> -------------------------------------------------
> Jane Vohden
> Database Administrator
> Fairbanks North Star Borough
> --------------------------------------------------
--
-----------------------------------------------------------------
Brett's 12th law of UNIX administration...
People tend not to react well when they lose control over their
computers. Typically, it brings out the worst in them ...
-----------------------------------------------------------------
Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings.
Tel. +27 31 717 4000 Direct. +27 31 717 4146
Fax. +27 31 717 4001
-----------------------------------------------------------------
The little voices are talking to me again, telling me to reach
for a keyboard and type rm -rf /*
last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'`
now I fear I have no answers
-----------------------------------------------------------------