Creation of a table

Print
PDF

To create a new table on the screen properties of the database, enter the name of your table and the number of fields expected.


SQLiteManager_Table1.png


You arrive on a screen allowing the seizure of properties of each field. SQLiteManager_Table2.png


We take the fields from our table. Note that in 'SQLite' field type 'Integer' design as a primary key is a field with auto-increment.
SQLiteManager_Table3.png
If you realize that you need only two made field! simply do not enter the field name.


And that's the result: SQLiteManager_Table4.png
It is possible to add 'No' or fields you want in the table!


To create 'index', you have a small summary in the table properties.


We want our field 'libel' is an 'Index' -> SQLiteManager_Table6.png
The result: SQLiteManager_Table7.png
We want to create another 'index': but just a column, then we wanted 3! Made add 2 columns: SQLiteManager_Table8.png -> SQLiteManager_Table9.png
And voila the job


SQLiteManager_Table10.png

Add comment

Security code
Refresh

Creation of a table - SQLiteManager
Facebook MySpace Twitter Digg Delicious Stumbleupon Google Bookmarks 

Author

SQLiteManager now is managed by the corporation WebInfoPro in order to remake to live this project all while remaining under license GPL

Contact

Vous pouvez nous contacter par email sur sqlitemanager@gmail.com

Who's online?

We have 1795 guests online