Image 1:
New in v1.6: Visually alter a table.
|
|
Image 2:
New in v1.6: Visually edit a record.
|
|
|
|
|
Image 3:
Once you are logged in successfully, you will see
either see a list of all database you have access to or the specific database as specified on the login screen. In this image you can see how PocketSqlMan gets all the columns indexes etc when they are actually accessed.
|
|
Image 4:
Once the list of columns etc is populated, you see them as depicted below.
|
|
|
|
|
Image 5:
The image below displays the way PocketSqlMan
displays the list of Stored procedures and views (image 6).
|
|
|
|
|
|
|
Image 7:
New in v1.6: Insert a record in table visually.
|
|
Image 8:
New: In the latest release is the ability to select a part of query and just execute it .. |
 |
|
 |
Image 9:
This screen displays the results returned by the T-SQL statements issued in the query pane.
The results are displayed one grid per T-SQL statement which returns some rows.
New: Improved scaling of grid, plus the resulting grids are now sortable.
|
|
Image 10:
New: .. and as you can see, it displays results in full screen when only one t-sql statement is executed.
|
 |
|
 |
|
Image 11:
If the results contains the primary key column also, then the rows are editable as well .. just click on a cell and it will turn editable, click anywhere else and that change will be tranfered to the db.
|
|
Image 12:
Here is the most relevant area of the application i.e. the area where you can run T-SQL statements on the database.
Pocket SQL Manager right now hasn't got support to run SPs (Stored Procedure) but it will be implemented in future.
Tip: Multiple queries can be issued by seperating the statements by a ';' (Semicolon). Plus you can save the query (Save selection to text file) to a file on your device, so that the next time you have to run that query, you can simply do Insert from text file and the execute it.
|
 |
|
 |
|
|
|
