Database Tools Available in Promis.e
There are two database interfaces available to the user for database interaction. The first, Visual SQL Query Builder, is a GUI-based interface. VSQL does not require users to key in the exact SQL query statement to interact with the database. The SQL statement is built as the user clicks the table and columns and selects criteria for queries from pull down menus. Execution of the auto-generated query statement produces query results in the form. Values can be edited or new rows can be added/deleted in the database by a click of a button.
The second is the SQL window and a series of tools from the Database toolbox. SQL (pronounced se-quel) stands for Structured Query Language. SQL is a simple yet powerful language that is the industry standard for database access and data manipulation.