ODBC 스키마 컬렉션(ADO.NET)
업데이트: November 2007
이 단원에서는 Microsoft SQL Server, Oracle 및 Microsoft Jet용 ODBC 드라이버에서 지원하는 스키마 컬렉션에 대해 설명합니다.
Microsoft SQL Server ODBC Driver
Microsoft SQL Server ODBC Driver에서는 공통 스키마 컬렉션을 비롯하여 다음과 같은 특정 스키마 컬렉션을 지원합니다.
Tables
Indexes
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Tables 및 Views
ColumnName |
DataType |
|---|---|
TABLE_CAT |
String |
TABLE_SCHEM |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
REMARKS |
String |
Indexes
ColumnName |
DataType |
|---|---|
TABLE_CAT |
String |
TABLE_SCHEM |
String |
TABLE_NAME |
String |
NON_UNIQUE |
Int16 |
INDEX_QUALIFIER |
String |
INDEX_NAME |
String |
TYPE |
Int16 |
ORDINAL_POSITION |
Int16 |
COLUMN_NAME |
String |
ASC_OR_DESC |
String |
CARDINATLITY |
Int32 |
PAGES |
Int32 |
FILTER_CONDITION |
String |
SS_TYPE_SCHEMA |
String |
SS_DATA_TYPE |
Byte |
Columns
ColumnName |
DataType |
|---|---|
TABLE_CAT |
String |
TABLE_SCHEM |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
COLUMN_SIZE |
Int32 |
BUFFER_LENGTH |
Int32 |
DECIMAL_DIGITS |
Int16 |
NUM_PREC_RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
COLUMN_DEF |
String |
SQL_DATA_TYPE |
Int16 |
SQL_DATETIME_SUB |
Int16 |
CHAR_OCTET_LENGTH |
Int32 |
ORDINAL_POSITION |
Int32 |
IS_NULLABLE |
String |
SS_TYPE_CATALOG |
String |
SS_TYPE_SCHEMA |
String |
SS_DATA_TYPE |
Byte |
Procedures
ColumnName |
DataType |
|---|---|
PROCEDURE_CAT |
String |
PROCEDURE_SCHEM |
String |
PROCEDURE_NAME |
String |
NUM_INPUT_PARAMS |
Int32 |
NUM_OUTPUT_PARAMS |
Int32 |
NUM_RESULT_SETS |
Int32 |
REMARKS |
String |
PROCEDURE_TYPE |
Int16 |
ProcedureColumns
ColumnName |
DataType |
|---|---|
PROCEDURE_CAT |
String |
PROCEDURE_SCHEM |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
COLUMN_SIZE |
Int32 |
BUFFER_LENGTH |
Int32 |
DECIMAL_DIGITS |
Int16 |
NUM_PREC_RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
COLUMN_DEF |
String |
SQL_DATA_TYPE |
Int16 |
SQL_DATETIME_SUB |
Int16 |
CHAR_OCTET_LENGTH |
Int32 |
ORDINAL_POSITION |
Int32 |
IS_NULLABLE |
String |
SS_TYPE_CATALOG |
String |
SS_TYPE_SCHEMA |
String |
SS_DATA_TYPE |
Byte |
ProcedureParameters
ColumnName |
DataType |
|---|---|
PROCEDURE_CAT |
String |
PROCEDURE_SCHEM |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
COLUMN_SIZE |
Int32 |
BUFFER_LENGTH |
Int32 |
DECIMAL_DIGITS |
Int16 |
NUM_PREC_RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
COLUMN_DEF |
String |
SQL_DATA_TYPE |
Int16 |
SQL_DATETIME_SUB |
Int16 |
CHAR_OCTET_LENGTH |
Int32 |
ORDINAL_POSITION |
Int32 |
IS_NULLABLE |
String |
SS_TYPE_CATALOG |
String |
SS_TYPE_SCHEMA |
String |
SS_DATA_TYPE |
Byte |
Microsoft Oracle ODBC Driver
Microsoft SQL Server Oracle ODBC Driver에서는 공통 스키마 컬렉션을 비롯하여 다음과 같은 특정 스키마 컬렉션을 지원합니다.
Tables
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Indexes
Tables 및 Views
ColumnName |
DataType |
|---|---|
TABLE_QUALIFIER |
String |
TABLE_OWNER |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
REMARKS |
String |
Columns
ColumnName |
DataType |
|---|---|
TABLE_QUALIFIER |
String |
TABLE_OWNER |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
PRECISION |
Int32 |
LENGTH |
Int32 |
SCALE |
Int16 |
RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
ORDINAL_POSITION |
Int32 |
Procedures
ColumnName |
DataType |
|---|---|
PROCEDURE_QUALIFIER |
String |
PROCEDURE_OWNER |
String |
PROCEDURE_NAME |
String |
NUM_INPUT_PARAMS |
Int16 |
NUM_OUTPUT_PARAMS |
Int16 |
NUM_RESULT_SETS |
Int16 |
REMARKS |
String |
PROCEDURE_TYPE |
Int16 |
ProcedureColumns
ColumnName |
DataType |
|---|---|
PROCEDURE_QUALIFIER |
String |
PROCEDURE_OWNER |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
PRECISION |
Int32 |
LENGTH |
Int32 |
SCALE |
Int16 |
RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
OVERLOAD |
Int32 |
ORDINAL_POSITION |
Int32 |
Microsoft Jet ODBC Driver
Microsoft Jet ODBC Driver에서는 공통 스키마 컬렉션을 비롯하여 다음과 같은 특정 스키마 컬렉션을 지원합니다.
Tables
Indexes
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Tables 및 Views
ColumnName |
DataType |
|---|---|
TABLE_QUALIFIER |
String |
TABLE_OWNER |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
REMARKS |
String |
Columns
ColumnName |
DataType |
|---|---|
TABLE_QUALIFIER |
String |
TABLE_OWNER |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
PRECISION |
Int32 |
LENGTH |
Int32 |
SCALE |
Int16 |
RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
ORDINAL_POSITION |
Int32 |
Procedures
ColumnName |
DataType |
|---|---|
PROCEDURE_QUALIFIER |
String |
PROCEDURE_OWNER |
String |
PROCEDURE_NAME |
String |
NUM_INPUT_PARAMS |
Int16 |
NUM_OUTPUT_PARAMS |
Int16 |
NUM_RESULT_SETS |
Int16 |
REMARKS |
String |
PROCEDURE_TYPE |
Int16 |
ProcedureColumns
ColumnName |
DataType |
|---|---|
PROCEDURE_QUALIFIER |
String |
PROCEDURE_OWNER |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
PRECISION |
Int32 |
LENGTH |
Int32 |
SCALE |
Int16 |
RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
OVERLOAD |
Int32 |
ORDINAL_POSITION |
Int32 |
ProcedureParameters
ColumnName |
DataType |
|---|---|
PROCEDURE_CAT |
String |
PROCEDURE_SCHEM |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
COLUMN_SIZE |
Int32 |
BUFFER_LENGTH |
Int32 |
DECIMAL_DIGITS |
Int16 |
NUM_PREC_RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
COLUMN_DEF |
String |
SQL_DATA_TYPE |
Int16 |
SQL_DATETIME_SUB |
Int16 |
CHAR_OCTET_LENGTH |
Int32 |
ORDINAL_POSITION |
Int32 |
IS_NULLABLE |
String |