SQL Support
Studio's SQL Support creates a convenient interface between Studio's
development environment and SQL databases. The SQL feature set will be
of enormous help to developers writing business and database applications
and/or working in the team environment.
About
Studio's SQL Tool allows you to add and/or configure a connection to
an SQL server. This feature set then allows you to view the structure
of an SQL database from within the Studio development environment. You
can view or edit the table data or procedures stored in the database.
Alternatively, if your PHP application is designed to create a new SQL
relational database, Studio's SQL Tool enables you to view the new database
and its contents. Most importantly, you can do all this without having
to rely on 3rd-party SQL utilities.
List of Functions
SQL Support provides the following functions:
|
|
SQL Server Configuration - Allows
you to configure the SQL Server Settings |
|
|
SQL Server Tree - Allows you
to view the database structure that is composed with schemas, tables,
stored procedures, indices etc. |
|
|
SQL Query Functions - Allows
you to run SQL query (statements) on a selected location. |
|
|
Messages - Returns an error
message if the query script fails to execute properly. |
|
|
Results (Edit
mode) - Allows you to edit the contents of the table. |
|
|
Text Viewer, Hex Viewer and Image Viewer
- Allows you to view the contents of a table cell that contains textual
data or binary data in a form of Blobs and Clobs. |
