Home Forums Database Design Design Ideas and Questions Schema binding across multiple databases RE: Schema binding across multiple databases

  • February 18, 2015 at 9:59 am

    #1778407

    you can create a view, but Not with schemabinding.

    Tables and user-defined functions must be referenced by two-part names in the view. One-part, three-part, and four-part names are not allowed.

    since a differnet database is referenced via a three part name, for example, and since there's no way to create true referential integrity accross multipel databases in SQL server, it's not possible with schemabinding.

    max.shrimps (2/18/2015)

    I have a similar need.

    The view points at a table (a table that stores daily currency exchange rates) in a different database (the master database that stores all shared data).

    Replies in this thread are confusing.

    In short, can you create a view WITH SCHEMABINDING to a table in a different database?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!