Home Forums SQL Server 7,2000 SQL Server Newbies Create Schema Alias References Another Schema RE: Create Schema Alias References Another Schema

  • June 21, 2008 at 1:49 pm

    #832279

    Not automatically. I think that you would have to create Views/Synonyms in your CI schema to map to the objects in your CS schema.

    Plus, I don't think that Case-Sensitivity or collation is a schema attribute, so you might have to put the CI schema in a different database.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]