---
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: 
  - "View"
helpviewer_keywords: 
  - "View object [ADOX]"
ms.assetid: 653421ce-7b94-43d0-9bc6-4900f8f2af45
author: MightyPen
ms.author: genemi
---
# View Object (ADOX)
Represents a filtered set of records or a virtual table. When used in conjunction with the ADO [Command](../../../ado/reference/ado-api/command-object-ado.md) 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](../../../ado/reference/adox-api/name-property-adox.md) property.  
  
-   Specify the ADO **Command** object that can be used to add, delete, or modify views with the [Command](../../../ado/reference/adox-api/command-property-adox.md) property.  
  
-   Return date information with the [DateCreated](../../../ado/reference/adox-api/datecreated-property-adox.md) and [DateModified](../../../ado/reference/adox-api/datemodified-property-adox.md) properties.  
  
 This section contains the following topic.  
  
-   [View Object Properties, Methods, and Events](../../../ado/reference/adox-api/view-object-properties-methods-and-events.md)  
  
## See Also  
 [Views and Fields Collections Example (VB)](../../../ado/reference/adox-api/views-and-fields-collections-example-vb.md)   
 [Views Append Method Example (VB)](../../../ado/reference/adox-api/views-append-method-example-vb.md)   
 [Views Collection, CommandText Property Example (VB)](../../../ado/reference/adox-api/views-collection-commandtext-property-example-vb.md)   
 [Views Delete Method Example (VB)](../../../ado/reference/adox-api/views-delete-method-example-vb.md)   
 [Views Collection (ADOX)](../../../ado/reference/adox-api/views-collection-adox.md)