| title | View Object (ADOX) | Microsoft Docs | |
|---|---|---|
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.reviewer | ||
| ms.topic | conceptual | |
| apitype | COM | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 653421ce-7b94-43d0-9bc6-4900f8f2af45 | |
| author | MightyPen | |
| ms.author | genemi |
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.
Views and Fields Collections Example (VB)
Views Append Method Example (VB)
Views Collection, CommandText Property Example (VB)
Views Delete Method Example (VB)
Views Collection (ADOX)