Home All Groups Group Topic Archive Search About
Author
12 Jan 2006 6:35 PM
rmg66
Is it possible to create a view in TSQL that references a table that cannot be verified.

Is there some sort of override.

I need to create a view that refences a table in another db. The other db cannot be available during creation.

Thanks, Robert

Author
13 Jan 2006 12:04 PM
Tibor Karaszi
There's no override option for this. SQL Server need to present meta-data for your view in the
system tables, and that meta-data is derived from the table(s) that the view references. Perhaps you
can create that other database temporarily, just so that you can create the view?

"rmg66" <rgwathney__xXx__primepro.com> wrote in message
news:%23Zc32b6FGHA.3100@tk2msftngp13.phx.gbl...
Is it possible to create a view in TSQL that references a table that cannot be verified.

Is there some sort of override.

I need to create a view that refences a table in another db. The other db cannot be available during
creation.

Thanks, Robert

AddThis Social Bookmark Button