legacyAlterTable

Queries or sets the legacy_alter_table flag.

When enabled (true), SQLite uses the legacy behavior for the ALTER TABLE RENAME command, where it does not update references to the renamed table in triggers and views. The new behavior (when false, the default) is to update these references automatically.

This pragma is primarily for backward compatibility with databases that were created with older versions of SQLite and might rely on the old ALTER TABLE behavior. It is generally recommended to leave this disabled.

See also