Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Brandie Tarvin Schema-Owned Tables and Generated DROP Scripts (SQL Spackl RE: Schema-Owned Tables and Generated DROP Scripts (SQL Spackl

  • August 2, 2013 at 9:44 am

    #1638240

    TheSQLGuru (8/2/2013)

    REALLY crammed with work this morning so didn't have time to set up a test or investigate, but is it possible to have 2+ tables with the same name belonging to different schemas each with a constraint named the same?

    I'll test as soon as I've finished with my month end emergencies.

    And if that is possible (which one would think it could be if all 3 parts are considered in "uniqueness" of a constraint object) I think all we would have a problem with some if not all of the article code.

    Are you saying my code won't work at all in these circumstances? Or do you mean something else by "some if not all of the article code"?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.