共用方式為


SystemDatatype Object

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The SystemDatatype object exposes the attributes of a Microsoft SQL Server base data type.

顯示目前物件的 SQL-DMO 物件模型

Properties

AllowIdentity Property

IsVariableLength Property

AllowLength Property

MaximumChar Property

AllowNulls Property

MaximumLength Property

IsNumeric Property

Name Property

備註

SQL Server defines base data types, such as varchar or smallint. The types constrain data in SQL Server columns to certain fundamental properties, such as numeric precision or value representation. SQL Server base data types have an established precedence for mixed-data type arithmetic performed on an instance of SQL Server.

A SystemDatatype object exists for each base data type defined by SQL Server.

The Name property of a SystemDatatype cannot be set by the user.

ms136895.note(zh-tw,SQL.90).gif附註:
The SystemDatatype object is compatible with instances of SQL Server versions 7.0 and later. However, the SystemDatatype2 object extends the functionality of the SystemDatatype object for use with features that were introduced in SQL Server 2000.

請參閱

參考

SystemDataType2 Object

說明及資訊

取得 SQL Server 2005 協助