7.5.4. Metadata

7.5.4. Metadata
Prev	7.5. OLE DB Provider for Virtuoso	Next

7.5.4. Metadata

Schema Rowsets

VIRTOLEDB supports schema rowsets listed in the following table.

DBSCHEMA_CATALOGS: All (CATALOG_NAME)
DBSCHEMA_COLUMN_PRIVILEGES: All (TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, GRANTOR, GRANTEE)
DBSCHEMA_COLUMNS: All (TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME)
DBSCHEMA_FOREIGN_KEYS: All (PK_TABLE_CATALOG, PK_TABLE_SCHEMA, PK_TABLE_NAME, FK_TABLE_CATALOG, FK_TABLE_SCHEMA, FK_TABLE_NAME)
DBSCHEMA_INDEXES: 1, 2, 3 and 5 (TABLE_CATALOG, TABLE_SCHEMA, INDEX_NAME, TABLE_NAME)
DBSCHEMA_PRIMARY_KEYS: All (TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME)
DBSCHEMA_PROCEDURE_PARAMETERS: All (PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME, PARAMETER_NAME)
DBSCHEMA_PROCEDURES: All (PROCEDURE_CATALOG, PROCEDURE_SCHEMA, PROCEDURE_NAME, PROCEDURE_TYPE)
DBSCHEMA_PROVIDER_TYPES: All (DATA_TYPE, BEST_MATCH)
DBSCHEMA_SCHEMATA: All (CATALOG_NAME, SCHEMA_NAME, SCHEMA_OWNER)
DBSCHEMA_TABLE_PRIVILEGES: All (TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, GRANTOR, GRANTEE)
DBSCHEMA_TABLES: All (TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE)

Columns Rowset

VIRTOLEDB supports the following columns in the columns rowset.

DBCOLUMN_IDNAME
DBCOLUMN_GUID
DBCOLUMN_PROPID
DBCOLUMN_NAME
DBCOLUMN_NUMBER
DBCOLUMN_TYPE
DBCOLUMN_TYPEINFO
DBCOLUMN_COLUMNSIZE
DBCOLUMN_PRECISION
DBCOLUMN_SCALE
DBCOLUMN_FLAGS
DBCOLUMN_BASECATALOGNAME
DBCOLUMN_BASECOLUMNNAME
DBCOLUMN_BASESCHEMANAME
DBCOLUMN_BASETABLENAME
DBCOLUMN_COMPUTEMODE
DBCOLUMN_DATETIMEPRECISION
DBCOLUMN_ISCASESENSITIVE
DBCOLUMN_ISSEARCHABLE
DBCOLUMN_OCTETLENGTH
DBCOLUMN_KEYCOLUMN

Prev	Up	Next
7.5.3. Data Types	Home	7.5.5. Supported Interfaces

Prefix	IRI
schema	http://schema.org/
n4	http://creativecommons.org/licenses/by/4.0/
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
n5	http://www.openlinksw.com/#
n3	http://docs.openlinksw.com/virtuoso/metadata/
xsdh	http://www.w3.org/2001/XMLSchema#

Prefix	URI
xmlns:schema	http://schema.org/
xmlns:n4	http://creativecommons.org/licenses/by/4.0/
xmlns:rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
xmlns:n5	http://www.openlinksw.com/#
xmlns:n3	http://docs.openlinksw.com/virtuoso/metadata/
xmlns:xsdh	http://www.w3.org/2001/XMLSchema#

Prefix

URI

xmlns:schema

http://schema.org/

xmlns:n4

http://creativecommons.org/licenses/by/4.0/

xmlns:rdf

http://www.w3.org/1999/02/22-rdf-syntax-ns#

xmlns:n5

http://www.openlinksw.com/#

xmlns:n3

http://docs.openlinksw.com/virtuoso/metadata/

xmlns:xsdh

http://www.w3.org/2001/XMLSchema#

Subject	Predicate	Object
n3:	rdf:type	schema:TechArticle
n3:	rdf:type	schema:APIReference
n3:	schema:name	7.5.4.ÃÂ Metadata
n3:	schema:copyrightHolder	_:vb80922
n3:	schema:datePublished	2016-09-09 16:16:54
n3:	schema:headline	7.5.4.ÃÂ Metadata
n3:	schema:keywords	OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data
n3:	schema:license	n4:deed.en_US
n3:	schema:publisher	_:vb80921
n3:	schema:url	n3:
_:vb80921	rdf:type	schema:Organization
_:vb80921	schema:name	OpenLink Software
_:vb80921	schema:url	n5:this
_:vb80922	rdf:type	schema:Organization
_:vb80922	schema:name	OpenLink Software
_:vb80922	schema:url	n5:this

Subject

Predicate

Object

n3:

rdf:type

schema:TechArticle

n3:

rdf:type

schema:APIReference

n3:

schema:name

7.5.4.ÃÂ Metadata

n3:

schema:copyrightHolder

_:vb80922

n3:

schema:datePublished

2016-09-09 16:16:54

n3:

schema:headline

7.5.4.ÃÂ Metadata

n3:

schema:keywords

OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data

n3:

schema:license

n4:deed.en_US

n3:

schema:publisher

_:vb80921

n3:

schema:url

n3:

_:vb80921

rdf:type

schema:Organization

_:vb80921

schema:name

OpenLink Software

_:vb80921

schema:url

n5:this

_:vb80922

rdf:type

schema:Organization

_:vb80922

schema:name

OpenLink Software

_:vb80922

schema:url

n5:this

7.5.4. Metadata

Schema Rowsets

Columns Rowset

Namespace Prefixes

Statements

Namespace Prefixes

Statements