TYPE_ID
Returns the ID for a specified data type name.
Syntax
TYPE_ID ( [ 'schema_name'. ] 'type_name' )
Arguments
'schema_name'
Is the name of the schema where the type_name belongs.
'type_name''
Is the name of the data type. type_name is of type nvarchar. type_name can be a system data type.
Return types
nvarchar
Example
SELECT TYPE_ID('sys.char') AS [2 Part Data Type ID];