Dynamic Data Masking
- Dynamic Data Masking 9.8.4
- All Products
TDS Type | Microsoft SQL Server Type | Supported? |
---|---|---|
Fixed-Length Data Types
| ||
NULLTYPE = %x1F
| Null
| No
|
INT1TYPE = %x30
| TinyInt
| Yes
|
BITTYPE = %x32
| Bit
| Yes
|
INT2TYPE = %x34
| SmallInt
| Yes
|
INT4TYPE = %x38
| Int
| Yes
|
DATETIM4TYPE = %x3A
| SmallDateTime
| Yes
|
FLT4TYPE = %x3B
| Real
| Yes
|
MONEYTYPE = %x3C
| Money
| Yes
|
DATETIMETYPE = %x3D
| DateTime
| Yes
|
FLT8TYPE = %x3E
| Float
| Yes
|
MONEY4TYPE = %x7A
| SmallMoney
| Yes
|
INT8TYPE = %x7F
| BigInt
| Yes
|
Yes
| ||
Variable-Length Data Types
| ||
GUIDTYPE = %x24
| UniqueIdentifier
| No
|
INTNTYPE = %x26
| (see below)
| Yes
|
DECIMALTYPE = %x37
| Decimal (legacy support)
| Yes
|
NUMERICTYPE = %x3F
| Numeric (legacy support)
| Yes
|
BITNTYPE = %x68
| Bit
| Yes
|
DECIMALNTYPE = %x6A
| Decimal
| Yes
|
NUMERICNTYPE = %x6C
| Numeric
| Yes
|
FLTNTYPE = %x6D
| Float
| Yes
|
MONEYNTYPE = %x6E
| SmallMoney/Money
| Yes
|
DATETIMNTYPE = %x6F
| (see below)
| Yes
|
DATENTYPE = %x28
| (introduced in TDS 7.3)
| Yes
|
TIMENTYPE = %x29
| (introduced in TDS 7.3)
| Yes
|
DATETIME2NTYPE = %x2A
| (introduced in TDS 7.3)
| Yes
|
DATETIMEOFFSETNTYPE = %x2B
| (introduced in TDS 7.3)
| No
|
CHARTYPE = %x2F
| Char (legacy support)
| Yes
|
VARCHARTYPE = %x27
| VarChar (legacy support)
| Yes
|
BINARYTYPE = %x2D
| byte[]
| Yes
|
VARBINARYTYPE = %x25
| VarBinary (legacy support)
| Yes
|
BIGVARBINTYPE = %xA5
| VarBinary
| Yes
|
BIGVARCHRTYPE = %xA7
| VarChar
| Yes
|
BIGBINARYTYPE = %xAD
| Binary
| Yes
|
BIGCHARTYPE = %xAF
| Char
| Yes
|
NVARCHARTYPE = %xE7
| NVarChar
| Yes
|
NCHARTYPE = %xEF
| NChar
| Yes
|
XMLTYPE = %xF1
| XML (introduced in TDS 7.2)
| Yes
|
UDTTYPE = %xF0
| CLR UDT (introduced in TDS 7.2)
| No
|
TEXTTYPE = %x23
| Text
| Yes
|
IMAGETYPE = %x22
| Image
| No
|
NTEXTTYPE = %x63
| NText
| Yes
|
SSVARIANTTYPE = %x62
| Sql_Variant (introduced in TDS 7.2)
| No
|