The graphical interface supports all SQLite features. It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities. This page describes the principles of operation for the VDBE in SQLite version 2.7. VDBE Tutorial The VDBE is the subsystem within SQLite that does the actual work of executing SQL statements. Powerful means of SQL query parsing and analysis. Version 2 DataTypes A description of how SQLite version 2 handles SQL datatypes. Advanced SQL editor with syntax highlighting and code completion. Edit data in the grid using powerful in-place editors. Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats. Visualize and modify BLOB fields using the integrated Hex editor. Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints. Restructure any complex table without losing data. Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes. Import data from ADO data source, CSV files, SQL script or SQLite. Export data to CSV files, SQL script, Excel or SQLite. Copy tables between SQLite databases using drag and drop operations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |