---
title: "Creating and Dropping Views and Procedures Using ExtendedAnsiSQL | Microsoft Docs"
ms.custom: ""
ms.date: "01/19/2017"
ms.prod: sql
ms.prod_service: connectivity
ms.reviewer: ""
ms.technology: connectivity
ms.topic: conceptual
helpviewer_keywords: 
  - "extendedANSISQL [ODBC], views and procedures"
ms.assetid: 3e67627e-dbf2-4f38-b8bb-956c7dec9ad6
author: David-Engel
ms.author: v-daenge
---
# Creating and Dropping Views and Procedures Using ExtendedAnsiSQL
When the ExtendedAnsiSQL flag is turned on, Jet 4.0 supports the ability to create and drop views and procedures through SQL. These views and procedures will not be visible through Access.