Saturday, February 25, 2012

Override Checking...?

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 ca
nnot be available during creation.
Thanks, RobertThere's no override option for this. SQL Server need to present meta-data fo
r 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?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"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 ca
nnot be available during
creation.
Thanks, Robert

No comments:

Post a Comment