TechNet
Export (0) Print
Expand All

DataType Class

 

The DataType object represents a SQL Server data type.

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

System.Object
  Microsoft.SqlServer.Management.Smo.DataType

type DataType = 
    class
        interface IXmlSerializable
    end

NameDescription
System_CAPS_pubmethodDataType()

Initializes a new instance of the DataType class.

System_CAPS_pubmethodDataType(SqlDataType)

Initializes a new instance of the DataType class based on a specified SQL Server data type.

System_CAPS_pubmethodDataType(SqlDataType, Int32)

Initializes a new instance of the DataType class based on a specified SQL Server data type with specified precision or maximum length.

System_CAPS_pubmethodDataType(SqlDataType, Int32, Int32)

Initializes a new instance of the DataType class based on a specified SQL Server data type with the specified precision and scale.

System_CAPS_pubmethodDataType(SqlDataType, String)

Initializes a new instance of the DataType class based on a specified SQL Server data type with the specified type.

System_CAPS_pubmethodDataType(SqlDataType, String, String)

Initializes a new instance of the DataType class based on a specified SQL Server data type with the specified type and schema.

System_CAPS_pubmethodDataType(UserDefinedDataType)

Initializes a new instance of the DataType class based on a specified user-defined data type.

System_CAPS_pubmethodDataType(UserDefinedTableType)

Initializes a new instance of the DataType class based on a specified user-defined table type.

System_CAPS_pubmethodDataType(UserDefinedType)

Initializes a new instance of the DataType class based on a specified user-defined type.

System_CAPS_pubmethodDataType(XmlSchemaCollection)

Initializes a new instance of the DataType class based on a specified XML schema collection.

NameDescription
System_CAPS_pubpropertySystem_CAPS_staticBigInt

Gets a data type that specifies the BigInt definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticBit

Gets a data type that specifies the Bit definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticDate

The Date property returns a Date data type.

System_CAPS_pubpropertySystem_CAPS_staticDateTime

Gets a data type that specifies the DateTime definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticFloat

Gets a data type that specifies the Float definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticGeography

The geography data type represents data in a round-earth coordinate system. The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.

System_CAPS_pubpropertySystem_CAPS_staticGeometry

The Geometry property contains spatial data that represents information about the physical location and shape of geometric objects.

System_CAPS_pubpropertySystem_CAPS_staticHierarchyId

The HierarchyId property is used to identify a position in a hierarchy.

System_CAPS_pubpropertySystem_CAPS_staticImage

Gets a data type that specifies the Image definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticInt

Gets a data type that specifies the Int definition used in the data type.

System_CAPS_pubpropertyIsNumericType

System_CAPS_pubpropertyIsStringType

System_CAPS_pubpropertyMaximumLength

Gets the maximum length of the data type.

System_CAPS_pubpropertySystem_CAPS_staticMoney

Gets a data type that specifies the Money definition used in the data type.

System_CAPS_pubpropertyName

Gets the name of the data type.

System_CAPS_pubpropertySystem_CAPS_staticNText

Gets a data type that specifies the NText definition used in the data type.

System_CAPS_pubpropertyNumericPrecision

Gets or sets the numeric precision of the data type.

System_CAPS_pubpropertyNumericScale

Gets or sets the numeric scale of the data type.

System_CAPS_pubpropertySystem_CAPS_staticNVarCharMax

Gets a data type that specifies the VarCharMax definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticReal

Gets a data type that specifies the Money definition used in the data type.

System_CAPS_pubpropertySchema

Gets or sets the schema of the data type.

System_CAPS_pubpropertySystem_CAPS_staticSmallDateTime

Gets a data type that specifies the SmallDateTime definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticSmallInt

Gets a data type that specifies the SmallInt definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticSmallMoney

Gets a data type that specifies the SmallMoney definition used in the data type.

System_CAPS_pubpropertySqlDataType

Gets a data type that specifies the SqlDataType definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticSysName

Gets a data type that specifies the SysName definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticText

Gets a data type that specifies the Text definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticTimestamp

Gets a data type that specifies the TimeStamp definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticTinyInt

Gets a data type that specifies the TinyInt definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticUniqueIdentifier

Gets a data type that specifies the UniqueIdentifier definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticVarBinaryMax

Gets a data type that specifies the VarBinaryMax definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticVarCharMax

Gets a data type that specifies the VarCharMax definition used in the data type.

System_CAPS_pubpropertySystem_CAPS_staticVariant

Gets a data type that specifies the Variant definition used in the data type.

System_CAPS_pubpropertyXmlDocumentConstraint

Gets or sets a value that indicates how an XML document is formatted.

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticBinary(Int32)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticChar(Int32)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticDateTime2(Int32)

datetime2 is an extension of the existing datetime type. It has a large date range and large default fractional precision. It has a length of at least 19 positions.

System_CAPS_pubmethodSystem_CAPS_staticDateTimeOffset(Int32)

Returns values for year, month, day, valid time of day between 00:00:00 and 23:59:59:9999999 and offset, in hours, from UTC. It has a length of at least 25 positions.

System_CAPS_pubmethodSystem_CAPS_staticDecimal(Int32, Int32)

Returns an object that represents the specified type.

System_CAPS_pubmethodEquals(DataType)

Determines whether the specified data types are considered equal.

System_CAPS_pubmethodEquals(Object)

Determines whether the specified object is considered equal to the current data type.(Overrides Object.Equals(Object).)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

This method supports the SQL Server infrastructure and is not intended to be used directly from your code.(Overrides Object.GetHashCode().)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodSystem_CAPS_staticNChar(Int32)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticNumeric(Int32, Int32)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticNVarChar(Int32)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticTime(Int32)

Returns values for any valid time of day between 00:00:00 and 23:59:59:9999999. It has a length of at least eight positions and contains the time in hours, minutes, seconds and fractional seconds.

System_CAPS_pubmethodToString()

Returns the object in string format.(Overrides Object.ToString().)

System_CAPS_pubmethodSystem_CAPS_staticUserDefinedDataType(String)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticUserDefinedDataType(String, String)

Returns an object that represents the specified type with the specified schema.

System_CAPS_pubmethodSystem_CAPS_staticUserDefinedTableType(String)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticUserDefinedTableType(String, String)

Returns an object that represents the specified type with the specified schema.

System_CAPS_pubmethodSystem_CAPS_staticUserDefinedType(String)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticUserDefinedType(String, String)

Returns an object that represents the specified type with the specified schema.

System_CAPS_pubmethodSystem_CAPS_staticVarBinary(Int32)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticVarChar(Int32)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticXml(String)

Returns an object that represents the specified type.

System_CAPS_pubmethodSystem_CAPS_staticXml(String, String)

Returns an object that represents the specified type and with the specified schema.

System_CAPS_pubmethodSystem_CAPS_staticXml(String, String, XmlDocumentConstraint)

Returns an object that represents the specified type, schema and XML document constraint.

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.GetSchema()

Not implemented.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.ReadXml(XmlReader)

Deserializes the DAC type properties from an XML stream. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed..

System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.WriteXml(XmlWriter)

Serializes the data type properties to an XML stream. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed..

The DataType object is used to specify the type of data that is associated primarily with columns and parameters.

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show:
© 2016 Microsoft