Partager via


Properties (Alphabetical)

The properties listed in this section are contained in the designated property sets and property groups. (For a listing of properties organized by property group, see Properties by Property Groups.) The "Column?" designation for Rowset properties states whether the property can be set on individual columns or only on the rowset as a whole.

Important

The "Typical R/W" value for each property specifies whether that property can typically be read or written. Whether a particular property can actually be read or written is provider-specific and is returned in the dwPropFlags element of the DBPROPINFO structure.

DBPROP_ABORTPRESERVE

DBPROP_IRowsetScroll

DBPROP_ACCESSORDER

DBPROP_IRowsetUpdate

DBPROP_ACTIVESESSIONS

DBPROP_IRowsetView

DBPROP_ALTERCOLUMN

DBPROP_IScopedOperations

DBPROP_APPENDONLY

DBPROP_ISequentialStream

DBPROP_ASYNCTXNABORT

DBPROP_IStorage

DBPROP_ASYNCTXNCOMMIT

DBPROP_IStream

DBPROP_AUTH_CACHE_AUTHINFO

DBPROP_ISupportErrorInfo

DBPROP_AUTH_ENCRYPT_PASSWORD

DBPROP_IViewChapter

DBPROP_AUTH_INTEGRATED

DBPROP_IViewFilter

DBPROP_AUTH_MASK_PASSWORD

DBPROP_IViewRowset

DBPROP_AUTH_PASSWORD

DBPROP_IViewSort

DBPROP_AUTH_PERSIST_ENCRYPTED

DBPROP_LITERALBOOKMARKS

DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO

DBPROP_LITERALIDENTITY

DBPROP_AUTH_USERID

DBPROP_LOCKMODE

DBPROP_BLOCKINGSTORAGEOBJECTS

DBPROP_MAXINDEXSIZE

DBPROP_BOOKMARKINFO

DBPROP_MAXOPENCHAPTERS

DBPROP_BOOKMARKS

DBPROP_MAXOPENROWS

DBPROP_BOOKMARKSKIPPED

DBPROP_MAXORSINFILTER

DBPROP_BOOKMARKTYPE

DBPROP_MAXPENDINGROWS

DBPROP_BYREFACCESSORS

DBPROP_MAXROWS

DBPROP_CACHEDEFERRED

DBPROP_MAXROWSIZE

DBPROP_CANFETCHBACKWARDS

DBPROP_MAXROWSIZEINCLUDESBLOB

DBPROP_CANHOLDROWS

DBPROP_MAXSORTCOLUMNS

DBPROP_CANSCROLLBACKWARDS

DBPROP_MAXTABLESINSELECT

DBPROP_CATALOGLOCATION

DBPROP_MAYWRITECOLUMN

DBPROP_CATALOGTERM

DBPROP_MEMORYUSAGE

DBPROP_CATALOGUSAGE

DBPROP_MULTIPLECONNECTIONS

DBPROP_CHANGEINSERTEDROWS

DBPROP_MULTIPLEPARAMSETS

DBPROP_CLIENTCURSOR

DBPROP_MULTIPLERESULTS

DBPROP_COL_AUTOINCREMENT

DBPROP_MULTIPLESTORAGEOBJECTS

DBPROP_COL_DEFAULT

DBPROP_MULTITABLEUPDATE

DBPROP_COL_DESCRIPTION

DBPROP_NOTIFICATIONGRANULARITY

DBPROP_COL_FIXEDLENGTH

DBPROP_NOTIFICATIONPHASES

DBPROP_COL_INCREMENT

DBPROP_NOTIFYCOLUMNSET

DBPROP_COL_ISLONG

DBPROP_NOTIFYROWDELETE

DBPROP_COL_NULLABLE

DBPROP_NOTIFYROWFIRSTCHANGE

DBPROP_COL_PRIMARYKEY

DBPROP_NOTIFYROWINSERT

DBPROP_COL_SEED

DBPROP_NOTIFYROWRESYNCH

DBPROP_COL_UNIQUE

DBPROP_NOTIFYROWSETCHANGED

DBPROP_COLUMNDEFINITION

DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE

DBPROP_COLUMNLCID

DBPROP_NOTIFYROWSETRELEASE

DBPROP_COLUMNRESTRICT

DBPROP_NOTIFYROWUNDOCHANGE

DBPROP_COMMANDTIMEOUT

DBPROP_NOTIFYROWUNDODELETE

DBPROP_COMMITPRESERVE

DBPROP_NOTIFYROWUNDOINSERT

DBPROP_COMSERVICES

DBPROP_NOTIFYROWUPDATE

DBPROP_CONCATNULLBEHAVIOR

DBPROP_NULLCOLLATION

DBPROP_CONNECTIONSTATUS

DBPROP_OLEOBJECTS

DBPROP_CURRENTCATALOG

DBPROP_OPENROWSETSUPPORT

DBPROP_DATASOURCE_TYPE

DBPROP_ORDERBYCOLUMNSINSELECT

DBPROP_DATASOURCENAME

DBPROP_ORDEREDBOOKMARKS

DBPROP_DATASOURCEREADONLY

DBPROP_OTHERINSERT

DBPROP_DBMSNAME

DBPROP_OTHERUPDATEDELETE

DBPROP_DBMSVER

DBPROP_OUTPUTENCODING

DBPROP_DEFERRED

DBPROP_OUTPUTPARAMETERAVAILABILITY

DBPROP_DELAYSTORAGEOBJECTS

DBPROP_OUTPUTSTREAM

DBPROP_DSOTHREADMODEL

DBPROP_OWNINSERT

DBPROP_FILTERCOMPAREOPS

DBPROP_OWNUPDATEDELETE

DBPROP_FINDCOMPAREOPS

DBPROP_PERSISTENTIDTYPE

DBPROP_GENERATEURL

DBPROP_PREPAREABORTBEHAVIOR

DBPROP_GROUPBY

DBPROP_PREPARECOMMITBEHAVIOR

DBPROP_HETEROGENEOUSTABLES

DBPROP_PROCEDURETERM

DBPROP_HIDDENCOLUMNS

DBPROP_PROVIDERFILENAME

DBPROP_IAccessor

DBPROP_PROVIDERFRIENDLYNAME

DBPROP_IBindResource

DBPROP_PROVIDERMEMORY

DBPROP_IChapteredRowset

DBPROP_PROVIDEROLEDBVER

DBPROP_IColumnsInfo

DBPROP_PROVIDERVER

DBPROP_IColumnsInfo2

DBPROP_QUICKRESTART

DBPROP_IColumnsRowset

DBPROP_QUOTEDIDENTIFIERCASE

DBPROP_IConnectionPointContainer

DBPROP_REENTRANTEVENTS

DBPROP_IConvertType

DBPROP_REMOVEDELETED

DBPROP_ICreateRow

DBPROP_REPORTMULTIPLECHANGES

DBPROP_IDBAsynchStatus

DBPROP_RESETDATASOURCE

DBPROP_IDENTIFIERCASE

DBPROP_RETURNPENDINGINSERTS

DBPROP_IGetRow

DBPROP_ROW_BULKOPS

DBPROP_IGetSession

DBPROP_ROWRESTRICT

DBPROP_IGetSourceRow

DBPROP_ROWSET_ASYNCH

DBPROP_ILockBytes

DBPROP_ROWSETCONVERSIONSONCOMMAND

DBPROP_IMMOBILEROWS

DBPROP_ROWTHREADMODEL

DBPROP_IMultipleResults

DBPROP_SCHEMATERM

DBPROP_INDEX_AUTOUPDATE

DBPROP_SCHEMAUSAGE

DBPROP_INDEX_CLUSTERED

DBPROP_SERVERCURSOR

DBPROP_INDEX_FILLFACTOR

DBPROP_SERVERDATAONINSERT

DBPROP_INDEX_INITIALSIZE

DBPROP_SERVERNAME

DBPROP_INDEX_NULLCOLLATION

DBPROP_SESS_AUTOCOMMITISOLEVELS

DBPROP_INDEX_NULLS

DBPROP_SKIPROWCOUNTRESULTS

DBPROP_INDEX_PRIMARYKEY

DBPROP_SORTONINDEX

DBPROP_INDEX_SORTBOOKMARKS

DBPROP_SQLSUPPORT

DBPROP_INDEX_TEMPINDEX

DBPROP_STRONGIDENTITY

DBPROP_INDEX_TYPE

DBPROP_STRUCTUREDSTORAGE

DBPROP_INDEX_UNIQUE

DBPROP_SUBQUERIES

DBPROP_INIT_ASYNCH

DBPROP_SUPPORTEDTXNDDL

DBPROP_INIT_BINDFLAGS

DBPROP_SUPPORTEDTXNISOLEVELS

DBPROP_INIT_CATALOG

DBPROP_SUPPORTEDTXNISORETAIN

DBPROP_INIT_DATASOURCE

DBPROP_TABLESTATISTICS

DBPROP_INIT_GENERALTIMEOUT

DBPROP_TABLETERM

DBPROP_INIT_HWND

DBPROP_TBL_TEMPTABLE

DBPROP_INIT_IMPERSONATION_LEVEL

DBPROP_TRANSACTEDOBJECT

DBPROP_INIT_LCID

DBPROP_UNIQUEROWS

DBPROP_INIT_LOCATION

DBPROP_UPDATABILITY

DBPROP_INIT_LOCKOWNER

DBPROP_USERNAME

DBPROP_INIT_MODE

MDPROP_AGGREGATECELL_UPDATE

DBPROP_INIT_OLEDBSERVICES

MDPROP_AXES

DBPROP_INIT_PROMPT

MDPROP_FLATTENING_SUPPORT

DBPROP_INIT_PROTECTION_LEVEL

MDPROP_MDX_CASESUPPORT

DBPROP_INIT_PROVIDERSTRING

MDPROP_MDX_DESCFLAGS

DBPROP_INIT_TIMEOUT

MDPROP_MDX_FORMULAS

DBPROP_IParentRowset

MDPROP_MDX_JOINCUBES

DBPROP_IRow

MDPROP_MDX_MEMBER_FUNCTIONS

DBPROP_IRowChange

MDPROP_MDX_NONMEASURE_EXPRESSIONS

DBPROP_IRowSchemaChange

MDPROP_MDX_NUMERIC_FUNCTIONS

DBPROP_IRowset

MDPROP_MDX_OBJQUALIFICATION

DBPROP_IRowsetBookmark

MDPROP_MDX_OUTERREFERENCE

DBPROP_IRowsetChange

MDPROP_MDX_QUERYBYPROPERTY

DBPROP_IRowsetCurrentIndex

MDPROP_MDX_RANGEROWSET

DBPROP_IRowsetFind

MDPROP_MDX_SET_FUNCTIONS

DBPROP_IRowsetIdentity

MDPROP_MDX_SLICER

DBPROP_IRowsetIndex

MDPROP_MDX_STRING_COMPOP

DBPROP_IRowsetInfo

MDPROP_NAMED_LEVELS

DBPROP_IRowsetLocate

MDPROP_VISUALMODE

DBPROP_IRowsetRefresh