OLE DB 스키마 컬렉션(ADO.NET)
업데이트: November 2007
이 단원에서는 Microsoft SQL Server, Oracle 및 Microsoft Jet용 OLE DB 공급자에서 지원하는 스키마 컬렉션에 대해 설명합니다.
Microsoft SQL Server OLE DB 공급자
Microsoft SQL Server OLE DB Driver에서는 공통 스키마 컬렉션을 비롯하여 다음과 같은 특정 스키마 컬렉션을 지원합니다.
Tables
Columns
Procedures
ProcedureParameters
Catalog
Indexes
Tables
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
TABLE_GUID |
Guid |
DESCRIPTION |
String |
TABLE_PROPID |
Int64 |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
Columns
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_GUID |
Guid |
COLUMN_PROPID |
Int64 |
ORDINAL_POSITION |
Int64 |
COLUMN_HASDEFAULT |
Boolean |
COLUMN_DEFAULT |
String |
COLUMN_FLAGS |
Int64 |
IS_NULLABLE |
Boolean |
DATA_TYPE |
Int32 |
TYPE_GUID |
Guid |
CHARACTER_MAXIMUM_LENGTH |
Int64 |
CHARACTER_OCTET_LENGTH |
Int64 |
NUMERIC_PRECISION |
Int32 |
NUMERIC_SCALE |
Int16 |
DATETIME_PRECISION |
Int64 |
CHARACTER_SET_CATALOG |
String |
CHARACTER_SET_SCHEMA |
String |
CHARACTER_SET_NAME |
String |
COLLATION_CATALOG |
String |
COLLATION_SCHEMA |
String |
COLLATION_NAME |
String |
DOMAIN_CATALOG |
String |
DOMAIN_SCHEMA |
String |
DOMAIN_NAME |
String |
DESCRIPTION |
String |
COLUMN_LCID |
Int32 |
COLUMN_COMPFLAGS |
Int32 |
COLUMN_SORTID |
Int32 |
COLUMN_TDSCOLLATION |
Byte[] |
IS_COMPUTED |
Boolean |
Procedures
ColumnName |
DataType |
|---|---|
PROCEDURE_CATALOG |
String |
PROCEDURE_SCHEMA |
String |
PROCEDURE_NAME |
String |
PROCEDURE_TYPE |
Int16 |
PROCEDURE_DEFINITION |
String |
DESCRIPTION |
String |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
ProcedureParameters
ColumnName |
DataType |
|---|---|
PROCEDURE_CATALOG |
String |
PROCEDURE_SCHEMA |
String |
PROCEDURE_NAME |
String |
PARAMETER_NAME |
String |
ORDINAL_POSITION |
Int32 |
PARAMETER_TYPE |
Int32 |
PARAMETER_HASDEFAULT |
Boolean |
PARAMETER_DEFAULT |
String |
IS_NULLABLE |
Boolean |
DATA_TYPE |
Int32 |
CHARACTER_MAXIMUM_LENGTH |
Int64 |
CHARACTER_OCTET_LENGTH |
Int64 |
NUMERIC_PRECISION |
Int32 |
NUMERIC_SCALE |
Int16 |
DESCRIPTION |
String |
TYPE_NAME |
String |
LOCAL_TYPE_NAME |
String |
Catalog
ColumnName |
DataType |
|---|---|
CATALOG_NAME |
String |
DESCRIPTION |
String |
Indexes
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
INDEX_CATALOG |
String |
INDEX_SCHEMA |
String |
INDEX_NAME |
String |
PRIMARY_KEY |
Boolean |
UNIQUE |
Boolean |
CLUSTERED |
Boolean |
TYPE |
Int32 |
FILL_FACTOR |
Int32 |
INITIAL_SIZE |
Int32 |
NULLS |
Int32 |
SORT_BOOKMARKS |
Boolean |
AUTO_UPDATE |
Boolean |
NULL_COLLATION |
Int32 |
ORDINAL_POSITION |
Int64 |
COLUMN_NAME |
String |
COLUMN_GUID |
Guid |
COLUMN_PROPID |
Int64 |
COLLATION |
Int16 |
CARDINALITY |
Decimal |
PAGES |
Int32 |
FILTER_CONDITION |
String |
INTEGRATED |
Boolean |
Microsoft Oracle OLE DB 공급자
Microsoft Oracle OLE DB Driver에서는 공통 스키마 컬렉션을 비롯하여 다음과 같은 특정 스키마 컬렉션을 지원합니다.
Tables
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Indexes
Tables
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
TABLE_GUID |
Guid |
DESCRIPTION |
String |
TABLE_PROPID |
Int64 |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
Columns
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_GUID |
Guid |
COLUMN_PROPID |
Int64 |
ORDINAL_POSITION |
Int64 |
COLUMN_HASDEFAULT |
Boolean |
COLUMN_DEFAULT |
String |
COLUMN_FLAGS |
Int64 |
IS_NULLABLE |
Boolean |
DATA_TYPE |
Int32 |
TYPE_GUID |
Guid |
CHARACTER_MAXIMUM_LENGTH |
Int64 |
CHARACTER_OCTET_LENGTH |
Int64 |
NUMERIC_PRECISION |
Int32 |
NUMERIC_SCALE |
Int16 |
DATETIME_PRECISION |
Int64 |
CHARACTER_SET_CATALOG |
String |
CHARACTER_SET_SCHEMA |
String |
CHARACTER_SET_NAME |
String |
COLLATION_CATALOG |
String |
COLLATION_SCHEMA |
String |
COLLATION_NAME |
String |
DOMAIN_CATALOG |
String |
DOMAIN_SCHEMA |
String |
DOMAIN_NAME |
String |
DESCRIPTION |
String |
Procedures
ColumnName |
DataType |
|---|---|
PROCEDURE_CATALOG |
String |
PROCEDURE_SCHEMA |
String |
PROCEDURE_NAME |
String |
PROCEDURE_TYPE |
Int16 |
PROCEDURE_DEFINITION |
String |
DESCRIPTION |
String |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
ProcedureColumns
ColumnName |
DataType |
|---|---|
PROCEDURE_CATALOG |
String |
PROCEDURE_SCHEMA |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_GUID |
Guid |
COLUMN_PROPID |
Int64 |
ROWSET_NUMBER |
Int64 |
ORDINAL_POSITION |
Int64 |
IS_NULLABLE |
Boolean |
DATA_TYPE |
Int32 |
TYPE_GUID |
Guid |
CHARACTER_MAXIMUM_LENGTH |
Int64 |
CHARACTER_OCTET_LENGTH |
Int64 |
NUMERIC_PRECISION |
Int32 |
NUMERIC_SCALE |
Int16 |
DESCRIPTION |
String |
OVERLOAD |
Int16 |
Views
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
VIEW_DEFINITION |
String |
CHECK_OPTION |
Boolean |
IS_UPDATABLE |
Boolean |
DESCRIPTION |
String |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
Indexes
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
INDEX_CATALOG |
String |
INDEX_SCHEMA |
String |
INDEX_NAME |
String |
PRIMARY_KEY |
Boolean |
UNIQUE |
Boolean |
CLUSTERED |
Boolean |
TYPE |
Int32 |
FILL_FACTOR |
Int32 |
INITIAL_SIZE |
Int32 |
NULLS |
Int32 |
SORT_BOOKMARKS |
Boolean |
AUTO_UPDATE |
Boolean |
NULL_COLLATION |
Int32 |
ORDINAL_POSITION |
Int64 |
COLUMN_NAME |
String |
COLUMN_GUID |
Guid |
COLUMN_PROPID |
Int64 |
COLLATION |
Int16 |
CARDINALITY |
Decimal |
PAGES |
Int32 |
FILTER_CONDITION |
String |
INTEGRATED |
Boolean |
Microsoft Jet OLE DB 공급자
Microsoft Jet OLE DB Driver에서는 공통 스키마 컬렉션을 비롯하여 다음과 같은 특정 스키마 컬렉션을 지원합니다.
Tables
Columns
Procedures
Views
Indexes
Tables
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
TABLE_GUID |
Guid |
DESCRIPTION |
String |
TABLE_PROPID |
Int64 |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
Columns
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_GUID |
Guid |
COLUMN_PROPID |
Int64 |
ORDINAL_POSITION |
Int64 |
COLUMN_HASDEFAULT |
Boolean |
COLUMN_DEFAULT |
String |
COLUMN_FLAGS |
Int64 |
IS_NULLABLE |
Boolean |
DATA_TYPE |
Int32 |
TYPE_GUID |
Guid |
CHARACTER_MAXIMUM_LENGTH |
Int64 |
CHARACTER_OCTET_LENGTH |
Int64 |
NUMERIC_PRECISION |
Int32 |
NUMERIC_SCALE |
Int16 |
DATETIME_PRECISION |
Int64 |
CHARACTER_SET_CATALOG |
String |
CHARACTER_SET_SCHEMA |
String |
CHARACTER_SET_NAME |
String |
COLLATION_CATALOG |
String |
COLLATION_SCHEMA |
String |
COLLATION_NAME |
String |
DOMAIN_CATALOG |
String |
DOMAIN_SCHEMA |
String |
DOMAIN_NAME |
String |
DESCRIPTION |
String |
Procedures
ColumnName |
DataType |
|---|---|
PROCEDURE_CATALOG |
String |
PROCEDURE_SCHEMA |
String |
PROCEDURE_NAME |
String |
PROCEDURE_TYPE |
Int16 |
PROCEDURE_DEFINITION |
String |
DESCRIPTION |
String |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
Views
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
VIEW_DEFINITION |
String |
CHECK_OPTION |
Boolean |
IS_UPDATABLE |
Boolean |
DESCRIPTION |
String |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
Indexes
ColumnName |
DataType |
|---|---|
TABLE_CATALOG |
String |
TABLE_SCHEMA |
String |
TABLE_NAME |
String |
INDEX_CATALOG |
String |
INDEX_SCHEMA |
String |
INDEX_NAME |
String |
PRIMARY_KEY |
Boolean |
UNIQUE |
Boolean |
CLUSTERED |
Boolean |
TYPE |
Int32 |
FILL_FACTOR |
Int32 |
INITIAL_SIZE |
Int32 |
NULLS |
Int32 |
SORT_BOOKMARKS |
Boolean |
AUTO_UPDATE |
Boolean |
NULL_COLLATION |
Int32 |
ORDINAL_POSITION |
Int64 |
COLUMN_NAME |
String |
COLUMN_GUID |
Guid |
COLUMN_PROPID |
Int64 |
COLLATION |
Int16 |
CARDINALITY |
Decimal |
PAGES |
Int32 |
FILTER_CONDITION |
String |
INTEGRATED |
Boolean |