DataType 클래스
The DataType object represents a SQL Server data type.
상속 계층
System.Object
Microsoft.SqlServer.Management.Smo.DataType
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
Public Class DataType _
Implements IXmlSerializable
‘사용 방법
Dim instance As DataType
public class DataType : IXmlSerializable
public ref class DataType : IXmlSerializable
type DataType =
class
interface IXmlSerializable
end
public class DataType implements IXmlSerializable
DataType 유형에서 다음 멤버를 표시합니다.
생성자
| 이름 | 설명 | |
|---|---|---|
.gif "공용 메서드") |
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. |
맨 위로 이동
속성
| 이름 | 설명 | |
|---|---|---|
.gif "공용 속성") .gif "정적 멤버") |
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. |
맨 위로 이동
메서드
| 이름 | 설명 | |
|---|---|---|
|
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. (Object.Equals(Object)을(를) 재정의함) |
|
Equals(DataType) | Determines whether the specified data types are considered equal. |
.gif "보호된 메서드") |
Finalize | (Object에서 상속됨) |
|
GetHashCode | This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Object.GetHashCode()을(를) 재정의함) |
|
GetType | (Object에서 상속됨) |
|
MemberwiseClone | (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. (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. |
맨 위로 이동
명시적 인터페이스 구현
| 이름 | 설명 | |
|---|---|---|
.gif "명시적 인터페이스 구현") .gif "전용 메서드") |
IXmlSerializable.GetSchema | Not implemented. |
|
IXmlSerializable.ReadXml | Deserializes the DAC type properties from an XML stream. 정보를 제공하기 위해서만 확인됩니다. 지원되지 않습니다. 향후 호환성은 보장되지 않습니다.. |
|
IXmlSerializable.WriteXml | Serializes the data type properties to an XML stream. 정보를 제공하기 위해서만 확인됩니다. 지원되지 않습니다. 향후 호환성은 보장되지 않습니다.. |
맨 위로 이동
주의
The DataType object is used to specify the type of data that is associated primarily with columns and parameters.
Thread Safety
이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.
예
스레드 보안
이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.