Book a Demo

Author Topic: Specify column default name  (Read 2198 times)

kateh

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Specify column default name
« on: January 24, 2008, 02:21:45 am »
I need to specify the names of column defaults so that when I create the SQL code from my EA model the defaults are named in the script.  


ie instead of

Code: [Select]

CREATE TABLE [dbo].[Project] (
[project_duration_scheme] int DEFAULT (0) NOT NULL,


I would want the script to be produced saying

Code: [Select]

CREATE TABLE [dbo].[Project] (
[project_duration_scheme] int
CONSTRAINT DF_project_duration_scheme DEFAULT (0) NOT NULL,


Is this possible?  

Thanks