Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
SQL programming tool
open-in-new
<h2 id="features">Features</h2> <p>SQL programming tools may include the following features: </p> <h3>SQL editing</h3> <p>SQL editors allow users to edit and execute SQL statements. They may support the following features: </p> <ul><li>cut, copy, paste, undo, redo, find (and replace), bookmarks</li> <li>block indent, print, save file, uppercase/lowercase</li> <li>keyword highlighting</li> <li>auto-completion</li> <li>access to frequently used files</li> <li>output of query result</li> <li>editing query-results</li> <li>committing and rolling-back transactions</li> <li>inside cut paper</li></ul> <h3>Object browsing</h3> <p>Tools may display information about <a href="/facts/Database_object/3Ref68CQ">database objects</a> relevant to developers or to database administrators. Users may: </p> <ul><li>view object descriptions</li> <li>view object <a href="/facts/Data_Definition_Language/Hx7aNozV">definitions</a> (DDL)</li> <li>create database objects</li> <li>enable and disable <a href="/facts/Database_trigger/yhI7KW6H">triggers</a> and <a href="/facts/Database_constraints/pEKGmJLy">constraints</a></li> <li>recompile valid or invalid objects</li> <li>query or edit <a href="/facts/Table_(database)/5INvK1Vd">tables</a> and <a href="/facts/View_(database)/6B00yj6A">views</a></li></ul> <p>Some tools also provide features to display dependencies among objects, and allow users to expand these dependent objects recursively (for example: packages may reference views, views generally reference tables, super/subtypes, and so on). </p> <h3>Session browsing</h3> <p>Database administrators and application developers can use session browsing tools to view the current activities of each user in the database. They can check the resource-usage of individual users, statistics information, locked objects and the current running SQL of each individual session. </p> <h3>User-security management</h3> <p>DBAs can create, edit, delete, disable or enable user-accounts in the database using security-management tools. DBAs can also assign roles, system <a href="/facts/Privilege_(computing)/7eS1wna4">privileges</a>, object privileges, and <a href="/facts/Database_storage/UxsT0h7u">storage</a>-quotas to users. </p> <h3>Debugging</h3> <p>Some tools offer features for the debugging of <a href="/facts/Stored_procedure/50xRehaI">stored procedures</a>: <a href="/facts/Program_animation/2BtbtxEN">step in</a>, step over, step out, run until exception, <a href="/facts/Breakpoint/LgtYUIlq">breakpoints</a>, view & set variables, view <a href="/facts/Call_stack/1sMt713v">call stack</a>, and so on. Users can debug any program-unit without making any modification to it, including triggers and <a href="/facts/Object_type/a49SD1kP">object types</a>. </p> <h3>Performance monitoring</h3> <p>Monitoring tools may show the database resources — usage summary, service time summary, recent activities, top sessions, session history or top SQL — in easy-to-read graphs. Database administrators can easily monitor the health of various components in the monitoring instance. Application developers may also make use of such tools to diagnose and correct application-performance problems as well as improve SQL server performance. </p> <h3>Test data</h3> <p>Test data generation tools can populate the database by realistic test data for server or client side testing purposes. Also, this kind of software can upload sample <a href="/facts/Binary_large_object/BzGnvlgo">blob</a> files to database. </p> <h2 id="see-also">See also</h2> <ul><li><a href="/facts/Comparison_of_database_administration_tools/CkDoCj7A">Comparison of database administration tools</a></li></ul>