Skip to content

alter-table-statement-limitations.md

Latest commit

 

History

History
23 lines (21 loc) · 1006 Bytes

alter-table-statement-limitations.md

File metadata and controls

23 lines (21 loc) · 1006 Bytes
title ALTER TABLE Statement Limitations | 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
ODBC SQL grammar, ALTER TABLE statement limitations
ALTER TABLE statement limitations [ODBC]
ms.assetid f3e88f85-edf4-47cd-a822-292b106ddb34
author David-Engel
ms.author v-daenge

ALTER TABLE Statement Limitations

When the dBASE or Paradox driver is used, once an index has been created and a new record added, the structure of the table cannot be changed by the ALTER TABLE statement unless the index is dropped and the contents of the table are deleted.

ALTER TABLE statements are not supported for the Microsoft Excel or Text drivers.

Note

When you use the Paradox driver without implementing the Borland Database Engine, ALTER TABLE statements are not supported; only read and append statements are allowed.