Skip to content

metadata-catalog.md

Latest commit

 

History

History
63 lines (56 loc) · 3.1 KB

metadata-catalog.md

File metadata and controls

63 lines (56 loc) · 3.1 KB
title Catalog Metadata | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology native-client
ms.topic reference
helpviewer_keywords
metadata [ODBC]
catalog metadata [ODBC]
ms.assetid b82665be-8cb1-4ad3-ac15-2e590bdc1815
author MightyPen
ms.author genemi
manager craigg

Catalog Metadata

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)