SQLXP lets you connect to any type of database by using ADO technology. Exploring databases by simply double-clicking the database objects in the browser window.
Develop SQL faster with syntax highlighting and code completion of tables, views, procedures, fields, and parameters.
Make your SQL robust with SQL Tuning for faster execution of statements, and server output to help you debug functions, procedures, and packages.
Develop reusable parameterized SQL statements by using SQLXP's Parameter Binding option, then store your SQL in the SQL repository for quick recall.
Create and Alter tables, views, functions, procedure, packages, and triggers.
Use the table viewer to view columns, keys, indexes and data. Add or remove columns, primary foreign keys, and indexes.
Edit table data directly, insert, update and delete records in the data grid.
Generate SQL statements from the database, create table, index and insert statements.
Use the command window to run SQL scripts like DDL statements created from the script generator.
Also use the command window to execute SQL statements against the database like PL\SQL blocks, then view the server output.
If you need SQL help, use the SQL Syntax window to get a list of SQL statements, and database functions.
SQLXP displays data in grid and text form, and allows you to export data to many different formats.
SQLXP also supports saving data to and from blob fields.
