Koleksi Skema OLE DB
Bagian ini membahas dukungan kumpulan skema untuk penyedia OLE DB untuk Microsoft SQL Server, Oracle, dan Microsoft Jet.
Penyedia OLE DB Microsoft SQL Server
Driver Microsoft SQL Server OLE DB mendukung kumpulan skema tertentu berikut selain kumpulan skema umum:
Tabel
Kolom
Prosedur
ProcedureParameters
Katalog
Indeks
Tabel
ColumnName | DataType |
---|---|
TABLE_CATALOG | String |
TABLE_SCHEMA | String |
TABLE_NAME | String |
TABLE_TYPE | String |
TABLE_GUID | Guid |
DESKRIPSI | String |
TABLE_PROPID | Int64 |
DATE_CREATED | DateTime |
DATE_MODIFIED | DateTime |
Kolom
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 |
DESKRIPSI | String |
COLUMN_LCID | Int32 |
COLUMN_COMPFLAGS | Int32 |
COLUMN_SORTID | Int32 |
COLUMN_TDSCOLLATION | Byte[] |
IS_COMPUTED | Boolean |
Prosedur
ColumnName | DataType |
---|---|
PROCEDURE_CATALOG | String |
PROCEDURE_SCHEMA | String |
PROCEDURE_NAME | String |
PROCEDURE_TYPE | Int16 |
PROCEDURE_DEFINITION | String |
DESKRIPSI | 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 |
DESKRIPSI | String |
TYPE_NAME | String |
LOCAL_TYPE_NAME | String |
Katalog
ColumnName | DataType |
---|---|
CATALOG_NAME | String |
DESKRIPSI | String |
Indeks
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 |
NULL | Int32 |
SORT_BOOKMARKS | Boolean |
AUTO_UPDATE | Boolean |
NULL_COLLATION | Int32 |
ORDINAL_POSITION | Int64 |
COLUMN_NAME | String |
COLUMN_GUID | Guid |
COLUMN_PROPID | Int64 |
PEMERIKSAAN | Int16 |
CARDINALITY | Decimal |
PAGES | Int32 |
FILTER_CONDITION | String |
TERINTEGRASI | Boolean |
Penyedia Microsoft Oracle OLE DB
Driver Microsoft Oracle OLE DB mendukung kumpulan skema tertentu berikut selain kumpulan skema umum:
Tabel
Kolom
Prosedur
ProcedureColumns
ProcedureParameters
Tampilan
Indeks
Tabel
ColumnName | DataType |
---|---|
TABLE_CATALOG | String |
TABLE_SCHEMA | String |
TABLE_NAME | String |
TABLE_TYPE | String |
TABLE_GUID | Guid |
DESKRIPSI | String |
TABLE_PROPID | Int64 |
DATE_CREATED | DateTime |
DATE_MODIFIED | DateTime |
Kolom
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 |
DESKRIPSI | String |
Prosedur
ColumnName | DataType |
---|---|
PROCEDURE_CATALOG | String |
PROCEDURE_SCHEMA | String |
PROCEDURE_NAME | String |
PROCEDURE_TYPE | Int16 |
PROCEDURE_DEFINITION | String |
DESKRIPSI | 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 |
DESKRIPSI | String |
OVERLOAD | Int16 |
Tampilan
ColumnName | DataType |
---|---|
TABLE_CATALOG | String |
TABLE_SCHEMA | String |
TABLE_NAME | String |
VIEW_DEFINITION | String |
CHECK_OPTION | Boolean |
IS_UPDATABLE | Boolean |
DESKRIPSI | String |
DATE_CREATED | DateTime |
DATE_MODIFIED | DateTime |
Indeks
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 |
NULL | Int32 |
SORT_BOOKMARKS | Boolean |
AUTO_UPDATE | Boolean |
NULL_COLLATION | Int32 |
ORDINAL_POSITION | Int64 |
COLUMN_NAME | String |
COLUMN_GUID | Guid |
COLUMN_PROPID | Int64 |
PEMERIKSAAN | Int16 |
CARDINALITY | Decimal |
PAGES | Int32 |
FILTER_CONDITION | String |
TERINTEGRASI | Boolean |
Penyedia Microsoft Jet OLE DB
Driver Microsoft Jet OLE DB mendukung kumpulan skema tertentu berikut selain kumpulan skema umum:
Tabel
Kolom
Prosedur
Tampilan
Indeks
Tabel
ColumnName | DataType |
---|---|
TABLE_CATALOG | String |
TABLE_SCHEMA | String |
TABLE_NAME | String |
TABLE_TYPE | String |
TABLE_GUID | Guid |
DESKRIPSI | String |
TABLE_PROPID | Int64 |
DATE_CREATED | DateTime |
DATE_MODIFIED | DateTime |
Kolom
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 |
DESKRIPSI | String |
Prosedur
ColumnName | DataType |
---|---|
PROCEDURE_CATALOG | String |
PROCEDURE_SCHEMA | String |
PROCEDURE_NAME | String |
PROCEDURE_TYPE | Int16 |
PROCEDURE_DEFINITION | String |
DESKRIPSI | String |
DATE_CREATED | DateTime |
DATE_MODIFIED | DateTime |
Tampilan
ColumnName | DataType |
---|---|
TABLE_CATALOG | String |
TABLE_SCHEMA | String |
TABLE_NAME | String |
VIEW_DEFINITION | String |
CHECK_OPTION | Boolean |
IS_UPDATABLE | Boolean |
DESKRIPSI | String |
DATE_CREATED | DateTime |
DATE_MODIFIED | DateTime |
Indeks
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 |
NULL | Int32 |
SORT_BOOKMARKS | Boolean |
AUTO_UPDATE | Boolean |
NULL_COLLATION | Int32 |
ORDINAL_POSITION | Int64 |
COLUMN_NAME | String |
COLUMN_GUID | Guid |
COLUMN_PROPID | Int64 |
PEMERIKSAAN | Int16 |
CARDINALITY | Decimal |
PAGES | Int32 |
FILTER_CONDITION | String |
TERINTEGRASI | Boolean |