SQLite Forum

Can FTS5 table be used as regular table?
Login
Can a virtual FTS5 table be used as if it were a regular table, or are there restrictions on its use?  Will triggers and check constraints work on them the same?

Is there anything that will not work correctly or at all on an FTS5 table?

Assuming no restrictions, is it preferred to use a regular table for storing data, and create an extra FTS5 virtual table just for searching specific columns?  Or, can the FTS5 table completely replace a regular table when at least one column needs MATCH-ing performance?