Using Transactions SECTION 12 Databases
195
12-7 Using Transactions
Modifications of data in the database i.e. adding, modifying and deleting
records, can be grouped so that all modifications take place at the same time.
This group of modifications is called a Transaction. A Transaction includes any
Schema Table
Constraints
CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
CONSTRAINT_TYPE
Schema Table Privileges TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
GRANTOR
GRANTEE
Schema Tables TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE
Schema Translations TRANSLATION_CATALOG
TRANSLATION_SCHEMA
TRANSLATION_NAME
Schema Usage Privileges OBJECT_CATALOG
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_TYPE
GRANTOR
GRANTEE
Schema View Column
Usage
VIEW_CATALOG
VIEW_SCHEMA
VIEW_NAME
Schema View Table
Usage
VIEW_CATALOG
VIEW_SCHEMA
VIEW_NAME
Schema Views TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
Note: The actual schemas are defined by the OLE DB specification and Providers
are not required to support all of the OLE DB standard schema queries.
Specifically, only 'Schema Tables', 'Schema Columns', and 'Schema Provider
Types' are required by the OLE DB specification. However, the provider is not
required to support the Criteria constraints listed above for those schema
queries.
To Next Page
Loading...
Need help?
General