The ORM Foundation

Get the facts!

NORMA incorrectly generating views?

Last post Fri, May 4 2012 19:46 by Anonymous. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • Fri, May 4 2012 18:23

    NORMA incorrectly generating views?

    I'm not sure if this is a bug or me just misunderstanding something but in the object role model which I've i've uploaded below, the entity type Project(.name) is being partially implemented as a VIEW in the generated Sql Server DDL


    CREATE VIEW Portfolio.Project_UC1 (WebsiteURL)
        SELECT WebsiteURL
        WHERE WebsiteURL IS NOT NULL


    Link to the ORM file:




  • Fri, May 4 2012 19:37 In reply to

    Re: NORMA incorrectly generating views?

    Hi Tom,

    The views are created for the uniqueness constraints on optional roles. You'll see a uniqueness constraint applied to this view after it is defined. Whether or not these views are generated depends on the behavior of the target DBMS when applying uniqueness constraints to null. You'll see them for uniqueness constraints that map to nullable columns in the database.


  • Fri, May 4 2012 19:46 In reply to

    Re: NORMA incorrectly generating views?

    Thanks for the clarification Matt :)

Page 1 of 1 (3 items)
© 2008-2022 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service