Classe DataType

The DataType object represents a SQL Server data type.

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public Class DataType _
    Implements IXmlSerializable
'Utilisation
Dim instance As DataType

public class DataType : IXmlSerializable

public ref class DataType : IXmlSerializable

type DataType =  
    class
        interface IXmlSerializable
    end

public class DataType implements IXmlSerializable

Le type DataType expose les membres suivants.

Constructeurs

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

Haut de la page

Propriétés

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

Haut de la page

Méthodes

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

Haut de la page

Implémentations d'interfaces explicites

	Nom	Description
	IXmlSerializable. . :: . .GetSchema	Not implemented.
	IXmlSerializable. . :: . .ReadXml	Deserializes the DAC type properties from an XML stream. Identifié à titre d'information uniquement. Non pris en charge. La compatibilité future n'est pas garantie..
	IXmlSerializable. . :: . .WriteXml	Serializes the data type properties to an XML stream. Identifié à titre d'information uniquement. Non pris en charge. La compatibilité future n'est pas garantie..

Haut de la page

Notes

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

Thread Safety

Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Exemples

Utilisation des types de données

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Management.Smo