View Object (ADOX)


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.

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.

This section contains the following topic.