Validation_Rule (object)

Refers to a column property that restricts what values can be stored in a column. A column can be assigned different validation rules for the server and client.

Valid Owning Object Types

Name DBMS Brands/Versions
ModelAll

Valid Owned Object Types

Name DBMS Brands/Versions
Extended_NotesAll
Valid_ValueAll

Tagged Values

Name Value
Long_Id{E7AB3CC0-47AD-4A10-8972-C0FB869EE7CB}+4020002c
tag_Display_Name_ResourceValidation Rule
tag_Display_Name_Resource_PluralValidation Rules
tag_Has_Dbms_Equivalenttrue
tag_Has_Udp_Editortrue
tag_Is_Abstractfalse
tag_Is_Logicaltrue
tag_Is_Physicaltrue
tag_Legacy_Ownership_Depth256
tag_Physical_Name_TextValidation Rule

Valid Property Types

Name DBMS Brands/Versions
Built_In_IdAll
CommentAll
Database_IdAll
DefinitionAll
Dependent_Objects_RefAll
Generate_As_Field_ProcedureDB2 for z/OS 8.1+
Generate_As_SQL_92_FormatDB2 for z/OS 6.0-8.0, Ingres 2.5+
Generate_Using_BindSQL Server 8.0+, Sybase 12.5+
Hide_In_LogicalAll
Hide_In_PhysicalAll
History_ListAll
Invert_ExpressionAll
Is_DetachedAll
Is_Logical_OnlyAll
Is_Not_For_ReplicationSQL Server 7.0+
Is_Physical_OnlyAll
Long_IdAll
NameAll
Name_QualifierAll
Note_ListAll
Object_GUIDAll
Owner_PathAll
Physical_NameAll
Quote_ValueAll
Schema_RefSQL Server 9.0+
Server_ValueAll
TypeAll
User_Formatted_NameAll
User_Formatted_Physical_NameAll
Validation_Rule_Error_MessageAccess 9.0+, Progress 8.0+
Validation_Rule_Max_ValueAll
Validation_Rule_Min_ValueAll