SQLite Limitation

Some Feature not Supported in SQLite

Feature	Support	Not Support
Right Outer Join	No	Only Left Outer Join
Full Outer Join	No	Only Left outer Join
Alter Table	·     Rename Table ·     Add Column ·     Alter Table commands are supported	·     Drop Column ·     Alter Column ·     Add Constraint Above commands are not supported
View	Yes(Read Only)	But View is read only You can’t execute following command in view ·     Delete ·     Insert ·     Update