MDAC 2.5 SDK - ODBC Desktop Database Drivers


 

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.