SQLite Forum

DROP VIEW IF EXISTS failure
Login
Are there parts of SQL syntax such that a table/view name might cause misinterpretation when it appears where a trigger or index name is expected?  I suspect that those roles could allow table/view names to be in a different namespace than trigger/index names (with revised language rules.) This is distinctly different from the situation with table versus view names, where they can appear interchangeably in some of the syntax.

(I grant this is not expressed as clearly as maybe it could be.)