UserDefinedDataType Properties

UserDefinedDataType Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAllowIdentity

Gets the Boolean property value that specifies whether the user-defined data type is able to participate in a column defined with the identity property.

System_CAPS_pubpropertyCollation

Gets the collation assigned to the user-defined data type.

System_CAPS_pubpropertyDefault

Gets or sets a SQL Server default that is bound to the user-defined data type.

System_CAPS_pubpropertyDefaultSchema

Gets or sets the SQL Server default schema for the user-defined data type.

System_CAPS_pubpropertyExecutionManager

(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyExtendedProperties

Gets the extended properties of the user-defined data type.

System_CAPS_pubpropertyID

Gets an ID value that uniquely identifies the user-defined data type.

System_CAPS_pubpropertyIsSchemaOwned

Gets a Boolean value that indicates whether the UserDefinedDataType object is owned by a schema.

System_CAPS_pubpropertyLength

Gets or sets the number of characters in the user-defined data type.

System_CAPS_pubpropertyMaxLength

Gets the maximum number of characters accepted by the user-defined data type.

System_CAPS_pubpropertyName

Gets or sets a String value that specifies the name of the user defined data type.(Overrides ScriptSchemaObjectBase.Name.)

System_CAPS_pubpropertyNullable

Gets or sets the Boolean property value that specifies whether the user-defined data type accepts null values or not.

System_CAPS_pubpropertyNumericPrecision

Gets or sets the maximum number of digits in a numeric value used in the definition of the user-defined data type.

System_CAPS_pubpropertyNumericScale

Gets or sets the maximum number of digits to the right of the decimal point in a numeric value used in the definition of the user-defined data type.

System_CAPS_pubpropertyOwner

Gets the name of the owner of the UserDefinedDataType object.

System_CAPS_pubpropertyParent

Gets or sets the Database object that is the parent of the UserDefinedDataType object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyRule

Gets or sets a SQL Server rule that is bound to the user-defined data type.

System_CAPS_pubpropertyRuleSchema

Gets or sets the SQL Server rule schema for the user-defined data type.

System_CAPS_pubpropertySchema

Gets or sets a String value that specifies the name of the schema that contains the user defined data type.(Overrides ScriptSchemaObjectBase.Schema.)

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertySystemType

Gets or sets the base system data type from which the user-defined data type is derived.

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyVariableLength

Gets the Boolean property value that specifies whether the user-defined data type is variable in length.

Return to top
Show:
© 2016 Microsoft