Data Types | Test Data Warehouse | Comments |
---|---|---|
Bigdatetime | Yes | |
Bigint | Yes | |
Bigtime | Yes | |
Bit | Yes | |
Binary (n) | Yes | |
Char (n) | Yes | |
Date | Yes | |
Datetime | Yes | |
Decimal (P,S) | Yes | You can enter a precision value up to 28. You cannot enter the data type with value Decimal(38,38). |
Double Precision | Yes | |
Float (P) | Yes | |
Image | Yes | |
Int | Yes | |
Longsysname | Yes | |
Money | Yes | |
Nchar (N) | Yes | |
Numeric (P,S) | Yes | You can enter a precision value up to 28. You cannot enter the data type with value Numeric(38,38). |
Nvarchar (N) | Yes | |
Real | Yes | |
Smalldatetime | Yes | |
Smallint | Yes | |
Smallmoney | Yes | |
Sysname | Yes | |
Text | Yes | |
Time | Yes | |
Tinyint | Yes | When you assign a data generation rule, ensure that you provide a range between 0 and 255. |
Unitext | Yes | |
Unsigned bigint | Yes | You cannot provide negative values. |
Unsigned int | Yes | You cannot provide negative values. |
Unsigned smallint | Yes | You cannot provide negative values. |
Unsigned tinyint | Yes | When you assign a data generation rule, ensure that you provide a range between 0 and 255. |
Varbinary (N) | Yes | |
Varchar (N) | Yes |