DataType Class

  • Article

The DataType object represents a SQL Server data type.

Inheritance Hierarchy

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

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

Syntax

'Declaration
Public Class DataType _
    Implements IXmlSerializable
'Usage
Dim instance As DataType

public class DataType : IXmlSerializable

public ref class DataType : IXmlSerializable

type DataType =  
    class 
        interface IXmlSerializable 
    end

public class DataType implements IXmlSerializable

The DataType type exposes the following members.

Constructors

  Name Description
Public method DataType() Initializes a new instance of the DataType class.
Public method DataType(SqlDataType) Initializes a new instance of the DataType class based on a specified SQL Server data type.
Public method DataType(UserDefinedDataType) Initializes a new instance of the DataType class based on a specified user-defined data type.
Public method DataType(UserDefinedTableType) Initializes a new instance of the DataType class based on a specified user-defined table type.
Public method DataType(UserDefinedType) Initializes a new instance of the DataType class based on a specified user-defined type.
Public method DataType(XmlSchemaCollection) Initializes a new instance of the DataType class based on a specified XML schema collection.
Public method DataType(SqlDataType, Int32) Initializes a new instance of the DataType class based on a specified SQL Server data type with specified precision or maximum length.
Public method DataType(SqlDataType, String) Initializes a new instance of the DataType class based on a specified SQL Server data type with the specified type.
Public method DataType(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.
Public method DataType(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.

Top

Properties

  Name Description
Public propertyStatic member BigInt Gets a data type that specifies the BigInt definition used in the data type.
Public propertyStatic member Bit Gets a data type that specifies the Bit definition used in the data type.
Public propertyStatic member Date The Date property returns a Date data type.
Public propertyStatic member DateTime Gets a data type that specifies the DateTime definition used in the data type.
Public propertyStatic member Float Gets a data type that specifies the Float definition used in the data type.
Public propertyStatic member Geography 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.
Public propertyStatic member Geometry The Geometry property contains spatial data that represents information about the physical location and shape of geometric objects.
Public propertyStatic member HierarchyId The HierarchyId property is used to identify a position in a hierarchy.
Public propertyStatic member Image Gets a data type that specifies the Image definition used in the data type.
Public propertyStatic member Int Gets a data type that specifies the Int definition used in the data type.
Public property MaximumLength Gets the maximum length of the data type.
Public propertyStatic member Money Gets a data type that specifies the Money definition used in the data type.
Public property Name Gets the name of the data type.
Public propertyStatic member NText Gets a data type that specifies the NText definition used in the data type.
Public property NumericPrecision Gets or sets the numeric precision of the data type.
Public property NumericScale Gets or sets the numeric scale of the data type.
Public propertyStatic member NVarCharMax Gets a data type that specifies the VarCharMax definition used in the data type.
Public propertyStatic member Real Gets a data type that specifies the Money definition used in the data type.
Public property Schema Gets or sets the schema of the data type.
Public propertyStatic member SmallDateTime Gets a data type that specifies the SmallDateTime definition used in the data type.
Public propertyStatic member SmallInt Gets a data type that specifies the SmallInt definition used in the data type.
Public propertyStatic member SmallMoney Gets a data type that specifies the SmallMoney definition used in the data type.
Public property SqlDataType Gets a data type that specifies the SqlDataType definition used in the data type.
Public propertyStatic member SysName Gets a data type that specifies the SysName definition used in the data type.
Public propertyStatic member Text Gets a data type that specifies the Text definition used in the data type.
Public propertyStatic member Timestamp Gets a data type that specifies the TimeStamp definition used in the data type.
Public propertyStatic member TinyInt Gets a data type that specifies the TinyInt definition used in the data type.
Public propertyStatic member UniqueIdentifier Gets a data type that specifies the UniqueIdentifier definition used in the data type.
Public propertyStatic member VarBinaryMax Gets a data type that specifies the VarBinaryMax definition used in the data type.
Public propertyStatic member VarCharMax Gets a data type that specifies the VarCharMax definition used in the data type.
Public propertyStatic member Variant Gets a data type that specifies the Variant definition used in the data type.
Public property XmlDocumentConstraint Gets or sets a value that indicates how an XML document is formatted.

Top

Methods

  Name Description
Public methodStatic member Binary Returns an object that represents the specified type.
Public methodStatic member Char Returns an object that represents the specified type.
Public methodStatic member DateTime2 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.
Public methodStatic member DateTimeOffset 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.
Public methodStatic member Decimal Returns an object that represents the specified type.
Public method Equals(Object) Determines whether the specified object is considered equal to the current data type. (Overrides Object.Equals(Object).)
Public method Equals(DataType) Determines whether the specified data types are considered equal.
Protected method Finalize (Inherited from Object.)
Public method GetHashCode This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Overrides Object.GetHashCode().)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public methodStatic member NChar Returns an object that represents the specified type.
Public methodStatic member Numeric Returns an object that represents the specified type.
Public methodStatic member NVarChar Returns an object that represents the specified type.
Public methodStatic member Time 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.
Public method ToString Returns the object in string format. (Overrides Object.ToString().)
Public methodStatic member UserDefinedDataType(String) Returns an object that represents the specified type.
Public methodStatic member UserDefinedDataType(String, String) Returns an object that represents the specified type with the specified schema.
Public methodStatic member UserDefinedTableType(String) Returns an object that represents the specified type.
Public methodStatic member UserDefinedTableType(String, String) Returns an object that represents the specified type with the specified schema.
Public methodStatic member UserDefinedType(String) Returns an object that represents the specified type.
Public methodStatic member UserDefinedType(String, String) Returns an object that represents the specified type with the specified schema.
Public methodStatic member VarBinary Returns an object that represents the specified type.
Public methodStatic member VarChar Returns an object that represents the specified type.
Public methodStatic member Xml(String) Returns an object that represents the specified type.
Public methodStatic member Xml(String, String) Returns an object that represents the specified type and with the specified schema.
Public methodStatic member Xml(String, String, XmlDocumentConstraint) Returns an object that represents the specified type, schema and XML document constraint.

Top

Explicit Interface Implementations

  Name Description
Explicit interface implemetationPrivate method IXmlSerializable.GetSchema Not implemented.
Explicit interface implemetationPrivate method IXmlSerializable.ReadXml Deserializes the DAC type properties from an XML stream. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed..
Explicit interface implemetationPrivate method IXmlSerializable.WriteXml Serializes the data type properties to an XML stream. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed..

Top

Remarks

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

Thread Safety

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.

Examples

Working with Data Types

Thread Safety

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

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace