DataType Members

  • Article

The DataType object represents a Microsoft SQL Server data type.

The following tables list the members exposed by the DataType type.

Public Constructors

  Name Description
DataType Overloaded. Initializes a new instance of the DataType class.

Top

Public Properties

  Name Description
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif BigInt Gets a data type that specifies the BigInt definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Bit Gets a data type that specifies the Bit definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif DateTime Gets a data type that specifies the DateTime definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Float Gets a data type that specifies the Float definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Image Gets a data type that specifies the Image definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Int Gets a data type that specifies the Int definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gif MaximumLength Gets the maximum length of the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Money Gets a data type that specifies the Money definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gif Name Gets the name of the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif NText Gets a data type that specifies the NText definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gif NumericPrecision Gets or sets the numeric precision of the data type.
ms219512.pubproperty(en-US,SQL.90).gif NumericScale Gets or sets the numeric scale of the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif NVarCharMax Gets a data type that specifies the NVarCharMax definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Real Gets a data type that specifies the Real definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gif Schema Gets or sets the schema of the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif SmallDateTime Gets a data type that specifies the SmallDateTime definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif SmallInt Gets a data type that specifies the SmallInt definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif SmallMoney Gets a data type that specifies the SmallMoney definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gif SqlDataType Gets a data type that specifies the SqlDataType definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif SysName Gets a data type that specifies the SysName definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Text Gets a data type that specifies the Text definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Timestamp Gets a data type that specifies the TimeStamp definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif TinyInt Gets a data type that specifies the TinyInt definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif UniqueIdentifier Gets a data type that specifies the UniqueIdentifier definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif VarBinaryMax Gets a data type that specifies the VarBinaryMax definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif VarCharMax Gets a data type that specifies the VarCharMax definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Variant Gets a data type that specifies the Variant definition used in the data type.
ms219512.pubproperty(en-US,SQL.90).gif XmlDocumentConstraint  

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Binary Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Char Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Decimal Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219512.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219512.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif NChar Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Numeric Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif NVarChar Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219512.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns the object in string format.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif UserDefinedDataType Overloaded. Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif UserDefinedType Overloaded. Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif VarBinary Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif VarChar Returns an object that represents the specified type.
ms219512.pubmethod(en-US,SQL.90).gifms219512.static(en-US,SQL.90).gif Xml Overloaded. Returns an object that represents the specified type.

Top

Protected Methods

  Name Description
ms219512.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219512.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

DataType Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Working with Data Types