Metadata - Catalog

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

This topic describes the column metadata returned by SQLColumns and SQLProcedureColumns, and the data type metadata returned by SQLGetTypeInfo.

Remarks

The following column values are returned for date/time types by SQLColumns and SQLProcedureColumns.

Parameter Type	date	time	smalldatetime	datetime	datetime2	datetimeoffset
DATA_TYPE	SQL_TYPE_DATE	SQL_SS_TIME2	SQL_TYPE_TIMESTAMP	SQL_TYPE_TIMESTAMP	SQL_TYPE_TIMESTAMP	SQL_SS_TIMESTAMPOFFSET
TYPE_NAME	date	time	smalldatetime	datetime	datetime2	datetimeoffset
COLUMN_SIZE	10	8,10..16	16	23	19, 21..27	26, 28..34
BUFFER_LENGTH	6	10	16	16	16	20
DECIMAL_DIGITS	0	0..7	0	3	1..7	1..7
SQL_DATA_TYPE	SQL_DATETIME	SQL_SS_TYPE_TIME2	SQL_DATETIME	SQL_DATETIME	SQL_DATETIME	SQL_SS_TYPE_TIMESTAMPOFFSET
SQL_DATETIME_SUB	SQL_CODE_DATE	NULL	SQL_CODE_TIMESTAMP	SQL_CODE_TIMESTAMP	SQL_CODE_TIMESTAMP	NULL
CHAR_OCTET_LENGTH	NULL	NULL	NULL	NULL	NULL	NULL
SS_DATA_TYPE	0	0	111	111	0	0

The following column values are returned for date/time types by SQLGetTypeInfo:

Parameter Type	date	time	smalldatetime	datetime	datetime2	datetimeoffset
TYPE_NAME	date	time	smalldatetime	datetime	datetime2	datetimeoffset
DATA_TYPE	SQL_TYPE_DATE	SQL_SS_TIME2	SQL_TYPE_TIMESTAMP	SQL_TYPE_TIMESTAMP	SQL_TYPE_TIMESTAMP	SQL_SS_TIMESTAMPOFFSET
COLUMN_SIZE	10	16	16	23	27	34
LITERAL_PREFIX	'	'	'	'	'	'
LITERAL_SUFFIX	'	'	'	'	'	'
CREATE_PARAMS	NULL	scale	NULL	NULL	scale	scale
NULLABLE	SQL_NULLABLE	SQL_NULLABLE	SQL_NULLABLE	SQL_NULLABLE	SQL_NULLABLE	SQL_NULLABLE
CASE_SENSITIVE	SQL_FALSE	SQL_FALSE	SQL_FALSE	SQL_FALSE	SQL_FALSE	SQL_FALSE
SEARCHABLE	SQL_PRED_SEARCHABLE	SQL_PRED_SEARCHABLE	SQL_PRED_SEARCHABLE	SQL_PRED_SEARCHABLE	SQL_PRED_SEARCHABLE	SQL_PRED_SEARCHABLE
UNSIGNED_ATTRIBUTE	NULL	NULL	NULL	NULL	NULL	NULL
FXED_PREC_SCALE	SQL_FALSE	SQL_FALSE	SQL_FALSE	SQL_FALSE	SQL_FALSE	SQL_FALSE
AUTO_UNIQUE_VALUE	NULL	NULL	NULL	NULL	NULL	NULL
LOCAL_TYPE_NAME	date	time	smalldatetime	datetime	datetime2	datetimeoffset
MINIMUM_SCALE	0	0	0	3	0	0
MAXIMUM_SCALE	0	7	0	3	7	7
SQL_DATA_TYPE	SQL_DATETIME	SQL_SS_TIME2	SQL_DATETIME	SQL_DATETIME	SQL_DATETIME	SQL_SS_TYPE_TIMESTAMPOFFSET
SQL_DATETIME_SUB	SQL_CODE_DATE	NULL	SQL_CODE_TIMESTAMP	SQL_CODE_TIMESTAMP	SQL_CODE_TIMESTAMP	NULL
NUM_PREC_RADIX	NULL	NULL	NULL	NULL	NULL	NULL
INTERVAL_PRECISION	NULL	NULL	NULL	NULL	NULL	NULL
USERTYPE	0	0	12	22	0	0

See Also

Metadata (ODBC)