Skip to content

DROP VIEW not supported in build/sqlite #1927

@carloslfu

Description

@carloslfu

DROP VIEW statement is not supported by SQLite build. Here is an example:

DROP VIEW IF EXISTS view_name;

The error that appears is:

[SyntaxError]: Expected "#", "--", "/*", ":=", "=", "INDEX", "TABLE", or [ \t\n\r] but "V" found.
    at peg$buildStructuredError (/Users/taozhi/Workspaces/OpenSources/node-sql-parser/pegjs/sqlite.pegjs:2548:12)
    at typeCase (/Users/taozhi/Workspaces/OpenSources/node-sql-parser/pegjs/sqlite.pegjs:24598:11)

I'd like to help with this one as it looks very similar to #1694 and I could use what you did to solve it via #1695 @taozhi8833998. This seems like a good start for me since I'll be using this library a lot and would like to contribute to it. WDYT?

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions