Return
-
Title
Creating a data type, -
Description
The scenario is as follows: I have a custom data type which declares the data type as NOT NULL however when I apply the data type to an attribute of
a table, the table is generated with the table's attribute constraint NULL/NOT NULL setting instead of adhering to the custom data type setting -
this seems to in part defeat the purpose of a custom data type. I'm using sql server 2008.
-
Resolution
You can create custom data types in MS 08 models, but there is no way to visually specify NOT NULL settings for custom data types.
Below a script that will set NULL or NOT NULL settings on attributes with the dictionary type.
How to execute the script:
Click Settings | Options and in section General enable Expert Mode.
Then click Tools | Scripting Window and copy and paste there the following script and execute it. (Of course, backup your model first).function main()
{
var app = System.GetInterface('Application');
var Model = app.Models.GetObject(0);
//... parameter in GetObject determines with which model the script should work.
//0 = first model listed in the Application View, 1 = second model listed in the Application View etc.
var e, Entity, a, Attribute;Model.Lock();for (e=0; e<Model.Entities.Count; e++)
{
Entity = Model.Entities.GetObject(e);
Entity.Lock();
for (a=0; a<Entity.Attributes.Count; a++)
{
Attribute = Entity.Attributes.GetObject(a);
if ((Attribute.DictType != null) && !Attribute.NotNull && Attribute.DictType.NotNull)
{
Attribute.NotNull = true;
Log.Information("NotNull was set in attribute "+Attribute.Name+" in "+Entity.Name);
}
}
Entity.UnLock();
}Model.UnLock();
}