The SystemDatatype object exposes the attributes of a Microsoft® SQL Server™ base data type.
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 a server running 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.
| AllowIdentity Property | IsVariableLength Property |
| AllowLength Property | MaximumChar Property |
| AllowNulls Property | MaximumLength Property |
| IsNumeric Property | Name Property |