Book a Demo

Author Topic: EA11 - Renaming Sequences for AutoNum columns  (Read 3069 times)

Morcous

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
EA11 - Renaming Sequences for AutoNum columns
« on: April 03, 2015, 04:05:28 am »
Is there a way to specify the default name for a Sequence or Trigger when using the AutoNum property to generate it in the DDL?

Right now, when I set an identity column to be AutoNum=True, it generates a sequence and trigger in the ddl with the following names:

SEQ_TableName_ColumnName
TRG_TableName_ColumnName

I'd like it to generate SEQ_ColumnName (since many of our tables are very long, and the identity column names will match the table name with an _id at the end)

Is there a way to do this in EA11?

Thank you