Hello If you delete a table that is associated with a view. An error occurs when calling pragma_table_info
Example: CREATE TABLE COMPANY( ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL ); CREATE VIEW COMPANY_VIEW AS SELECT ID, NAME, AGE FROM COMPANY; DROP table 'COMPANY'; pragma table_info('COMPANY_VIEW'); Error: Uncaught Error: no such table: main.COMPANY As an option to automatically destroy all connected VIEW -- Best regards, Kirill mailto:kir...@aidagw.com _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users