|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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 cannot be available during creation. Thanks, Robert 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? -- 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 Is it possible to create a view in TSQL that references a table that cannot be verified.news:%23Zc32b6FGHA.3100@tk2msftngp13.phx.gbl... 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 |
|||||||||||||||||||||||