Creating a View

[Jerry III]

How about using fully qualified names? [Database].[owner].[object] should
work...

Jerry

"Micheal" <frooyo@sbcglobal.net> wrote in message
news:OOy09$FXDHA.1832@TK2MSFTNGP09.phx.gbl...

> I have 2 databases within SQL Server 2000. What I want to do is create a
> view in database A that references tables in database B. Is that possible
> and how?
>
> Thanks in advance
>
>

[Whit]

I am having a terrible time trying to create a view. Here is the sql
string:

$sql = "CREATE VIEW v AS SELECT * FROM t1;";

Here is the error:

You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'VIEW v
AS SELECT * FROM t1' at line 1

So simple, yet so vexing. Any thoughts? Thanks,

-- whit nelson

[Bill Karwin]

Whit wrote:

> I am having a terrible time trying to create a view.

Try this: "SELECT VERSION();"

If it says you are using a version prior to 5.0, then views are not
supported. Views are a new feature in 5.0.

Regards,
Bill K.