| SQL Editor with code completion |
Intelligent SQL editor allows you to create and edit SQL queries and scripts much faster, with less typing errors and with no need to constanly search for correct name of some table or column. DbOctopus offers completion of all SQL keywords and database objects: |
| JOINing few tables required lots of typing. Not anymore. With DbOctopus all you have to do is select relation and JOIN will be written for you:  |
| Basic commands like SELECT, INSERT, etc. can be autocreated and inserted into your query, where you can easily tweak them. That way you can quickly build scripts containing several SQL commands:  |
DbOctopus shows tooltips with list of parameters for stored procedures and functions: |
| Of course, once you get results from your query you can filter them further, export, etc. Most of features we have for tables is available here too.  |
| Database relations |
| Add foreign key table columns and you’ll automatically see joined data without any manual SQL. For example, if you have EmployeeID field that points to Employee table, you can include other data like Name or Title from that related table.
|
| Pick up all columns from foreign table that should be visible:
|
| Use lookup values from foreign table instead of manually entering IDs:
|
| Display parent and child tables simultaneously, and you’ll immediatelly see all related rows as you browse main table:
|
| Handling large tables |
| Start typing in auto filter (Excel like) field and table will be instantly filtered. Sort table by clicking column header.  |
| For more advanced queries there’s query builder:
|
| To group data simply drag column to Group area
|
| Find and replace through entire table just like it’s one big Excel sheet:
|
| Database structure and dependencies |
| Explore table and view columns:
|
| Explore table, view and sp dependencies – where they are referenced, which foreign keys they use, on which resources they depend:
|
| Support for stored procedures |
| Execute stored procedure. Store used parameters so that you don’t have to enter all of them each time:
|
| View color coded SQL:
|
| Pivot tables |
| Pivot tables, Excel like:
|
| Enhanced Copy and Paste |
| You can Copy and Paste multiple rows between tables or within single table:
|
| However, pasting multiple rows usualy fails because of table constraints – you’re trying to insert another row with same primary key:
|
| With DbOctopus you can just fix problematic fields which broke table contraints, and finish paste succesfully:
|
| Copy and paste is compatible with Excel, so you can directly copy to/from Excel tables:
|
| Export and import |
| Data from tables and views could be exported to XML, HTML, Excell ot Text files:
|
| Data can be imported from XML files. You can map which XML elements go to which database column:
|
