Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - 2005_guy

Pages: [1]
1
General Board / Column Default (SQL Server)
« on: August 24, 2007, 12:18:04 am »
As the SQL that creates a default does not specify a constraint name (create table test columna int not null default 0), the default is allocated a system assigned name at run time.  This causes problems later on when this default has to be manipulated, as a custom script is needed for each environment, due to the different system assigned default names.
Is there any way in EA to assign a column default as a named constraint (create table test columna NULL constraint DF_test_columna DEFAULT (0))?

thanks,
this is really messing up our release strategy

Pages: [1]