View Object

Represents a filtered set of records or a virtual table. When used in conjunction with the ADO Command object, the View object can be used for adding, deleting, or modifying views.

Remarks

A view is a virtual table, created from other database tables or views. The View object allows you to create a view without having to know or use the provider's "CREATE VIEW" syntax.

With the properties of a View object, you can:

• Identify the view with the Name property.
• Specify the ADO Command object that can be used to add, delete, or modify views with the Command property.
• Return date information with the DateCreated and DateModified properties.

See Also

Views and Fields Collections Example (VB) | Views Append Method Example (VB) | Views Collection, CommandText Property Example (VB) | Views Delete Method Example (VB)

Properties, Methods, and Events | Views Collection