SQLite Limitation

Posted by Suthahar on Sunday, September 15, 2013 No comments






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



Tags

Suthahar Jegatheesan is Mobile and Cloud Specialist/Architect and he has 15+ years of IT experience as a Technology Consultant /Programmer/Developer in IT industry. Suthahar is an industry luminary focused on AI, Computer Vision, Bot, Machine Learning, UWP, Azure, Xamarin and Web Emerging User Experiences as subject matter expert (SME) in implementation, architecture, development and administration.
Facebook
Google+
Linkedin
Pinterest
Delicious

0 Comments

Featured Post

Improving C# Performance by Using AsSpan and Avoiding Substring

During development and everyday use, Substring is often the go-to choice for string manipulation. However, there are cases where Substring c...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts