Catalog Object

Contains collections (Tables, Views, Users, Groups, and Procedures) that describe the schema catalog of a data source.

Remarks

You can modify the Catalog object by adding or removing objects or by modifying existing objects. Some providers may not support all of the Catalog objects or may support only viewing schema information.

With the properties and methods of a Catalog object, you can:

• Open the catalog by setting the ActiveConnection property to an ADO Connection object or a valid connection string.
• Create a new catalog with the Create method.
• Determine the owners of the objects in a Catalog with the GetObjectOwner and SetObjectOwner methods.

This section contains the following topic.

• Properties, Methods, and Events

See Also

Catalog ActiveConnection Property Example (VB) | Command and CommandText Properties Example (VB) | Connection Close Method, Table Type Property Example (VB) | Create Method Example (VB) | Keys Append Method, Key Type, RelatedColumn, RelatedTable and UpdateRule Properties Example (VB) | Parameters Collection, Command Property Example (VB) | ParentCatalog Property Example (VB) | Procedures Append Method Example (VB) | Procedures Delete Method Example (VB) | Procedures Refresh Method Example (VB) | Views and Fields Collections Example (VB) | Views Append Method Example (VB) | Views Collection, CommandText Property Example (VB) | Views Delete Method Example (VB) | Views Refresh Method Example (VB)

Groups Collection | Procedures Collection | Tables Collection | Users Collection | Views Collection