Welcome to ModelRight Database Design Tool - Database Modeling Done Right Sign in | Join | Help
in

Quote constraint name in generated script

Last post 10-09-2009, 6:06 PM by admin. 1 replies.
Sort Posts: Previous Next
  •  10-08-2009, 8:55 AM 1334

    Quote constraint name in generated script

    I refactored an existing database and discovered a constraint with a minus "-" in it's name. The tool we used before put quotes around this very constraint name and Oracle accepted it. ModelRight does not quote it, so creation fails.

    I was not aware of the fact that Oracle would accept it and I renamed the constraint immediately so the problem is solved for me.

    You might want to consider this in some future version though, since it's allowed by Oracle and others could have this problem too.

    Regards, Peter

  •  10-09-2009, 6:06 PM 1346 in reply to 1334

    Re: Quote constraint name in generated script

    Right.  We should auto-quote names that have special characters in them.  Will make sure it gets in.
    Scott Reynolds
    Technical Support Engineer
    ModelRight, Inc.
    www.modelright.com
    p: (609) 423-9296
    f: (866) 812-3742