| <?xml version="1.0" encoding="UTF-8"?> |
| <!DOCTYPE html |
| PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html lang="en" xml:lang="en"> |
| <head> |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| <meta name="copyright" content="(C) Copyright 2005"/> |
| <meta name="DC.rights.owner" content="(C) Copyright 2005"/> |
| <meta name="DC.Type" content="reference"/> |
| <meta name="DC.Title" content="SQL Query Builder Preferences"/> |
| <meta name="abstract" content="Indicate the SQL Query Builder preferences."/> |
| <meta name="description" content="Indicate the SQL Query Builder preferences."/> |
| <meta name="DC.subject" content="dtp"/> |
| <meta name="keywords" content="dtp"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700397808.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700399339.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700400855.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700404058.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700412058.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700397808.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700429574.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700435668.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700437325.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700441997.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700443669.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700445247.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700448153.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700449560.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700427574.html"/> |
| <meta name="DC.Creator" content="ekapner"/> |
| <meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\dtp\dtp\en\source\r_sql_query_builder_preferences.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="reference_945EEEBF0B60467196BB9E5D6FE3D0D5"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:26:50]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700410527"/> |
| <meta name="DC.Language" content="en"/> |
| <link rel="stylesheet" type="text/css" href="../../styles/commonltr.css"/> |
| <link rel="stylesheet" type="text/css" href="../../styles/doc.css"/> |
| <title xmlns:xs="http://www.w3.org/2001/XMLSchema">SQL Query Builder Preferences</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700410527"><a name="asc1229700410527"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">SQL Query Builder Preferences</h1> |
| |
| |
| |
| <div><p>Indicate the SQL Query Builder preferences.</p> |
| |
| |
| <div class="tablenoborder"><a name="asc1229700410527__table_62B833A8B4804C9A943A98BD1CD0D7E1"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700410527__table_62B833A8B4804C9A943A98BD1CD0D7E1" frame="border" border="1" rules="all"><caption><span class="tablecap">Table 1. SQL Query Builder preferences</span></caption> |
| |
| |
| <thead align="left"> |
| <tr> |
| <th class="cellrowborder" valign="top" width="NaN%" id="d2032e53">Field</th> |
| |
| <th class="cellrowborder" valign="top" width="NaN%" id="d2032e56">Description</th> |
| |
| </tr> |
| |
| </thead> |
| |
| |
| <tbody> |
| <tr> |
| <td class="cellrowborder" valign="top" width="NaN%" headers="d2032e53 ">Omit Current Schema in Generated SQL Statement</td> |
| |
| <td class="cellrowborder" valign="top" width="NaN%" headers="d2032e56 ">Select to indicate that the table references qualified by the current schema become unqualified in the SQL code.</td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" width="NaN%" headers="d2032e53 ">Current Schema</td> |
| |
| <td class="cellrowborder" valign="top" width="NaN%" headers="d2032e56 ">If you omit the current schema, select its replacement:<div class="p"> |
| <br/><a name="asc1229700410527__ul_397D52482FA049E3AE64F4E6FF7390F1"><!-- --></a><ul id="asc1229700410527__ul_397D52482FA049E3AE64F4E6FF7390F1"> |
| <li id="asc1229700410527__li_A84192BD12BA42E5A7F5C0B4BEF88201"><a name="asc1229700410527__li_A84192BD12BA42E5A7F5C0B4BEF88201"><!-- --></a>Authorization ID — uses the user name from the connection profile. |
| The table references are qualified using the current schema name.</li> |
| |
| <li id="asc1229700410527__li_4321B573E5924187BD9C85AF40AC24C7"><a name="asc1229700410527__li_4321B573E5924187BD9C85AF40AC24C7"><!-- --></a>Schema Name — enter the schema to use as the current schema.</li> |
| |
| </ul> |
| |
| </div> |
| |
| </td> |
| |
| </tr> |
| |
| </tbody> |
| |
| </table> |
| </div> |
| |
| </div> |
| |
| <div> |
| <div class="familylinks"> |
| <div class="parentlink"><strong>Parent topic:</strong> <a href="../../doc/html/asc1229700397808.html" title="Set SQL Development preferences for label decorations, execution plans, SQL Editor, SQL Query Builder, and SQL Results view.">Setting SQL Development Preferences</a></div> |
| </div> |
| <div class="relconcepts"><strong>Related concepts</strong><br/> |
| <div><a href="../../doc/html/asc1229700427574.html" title="Create, edit, or run SQL statements using the SQL Query Builder graphical interface, which provides access to your database schema and objects so that you can quickly create or edit SQL statements without actually typing any SQL code. However, you also have the flexibility to add or modify the SQL code in the editor window.">SQL Query Builder</a></div> |
| </div> |
| <div class="reltasks"><strong>Related tasks</strong><br/> |
| <div><a href="../../doc/html/asc1229700397808.html" title="Set SQL Development preferences for label decorations, execution plans, SQL Editor, SQL Query Builder, and SQL Results view.">Setting SQL Development Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700429574.html" title="Use SQL Query Builder to create a SELECT statement to retrieve data from a database and display the results set in table format.">Creating a SELECT Statement</a></div> |
| <div><a href="../../doc/html/asc1229700435668.html" title="Use SQL Query Builder to create an INSERT statement to insert new rows at the end of a table with the values you indicate for the specified columns.">Creating an INSERT Statement From a Values Set</a></div> |
| <div><a href="../../doc/html/asc1229700437325.html" title="Use SQL Query Builder to create an INSERT statement from a subquery.">Creating an INSERT Statement From a Subquery</a></div> |
| <div><a href="../../doc/html/asc1229700441997.html" title="Use SQL Query Builder to create an UPDATE statement to update data in a table. You can explicitly set the values or derive them from the results of a build expression.">Creating an UPDATE Statement</a></div> |
| <div><a href="../../doc/html/asc1229700443669.html" title="Use SQL Query Builder to create a DELETE statement to remove data from a specified table. By specifying one or more conditions, you can indicate which rows in the database table to delete. If you do not specify any conditions, all rows in the target table are deleted.">Creating a DELETE Statement</a></div> |
| <div><a href="../../doc/html/asc1229700445247.html" title="Use the Expression Builder in SQL Query Builder to build simple or complex expressions, or subqueries when creating SELECT, UPDATE, INSERT, and DELETE statements.">Building Expressions</a></div> |
| <div><a href="../../doc/html/asc1229700448153.html" title="Use SQL Query Builder to edit an individual SQL statement. You can only edit one SQL statement at a time.">Editing a SQL Statement</a></div> |
| <div><a href="../../doc/html/asc1229700449560.html" title="Use SQL Query Builder to run an individual SQL statement and view its execution results.">Running the SQL Statement Code</a></div> |
| </div> |
| <div class="relref"><strong>Related reference</strong><br/> |
| <div><a href="../../doc/html/asc1229700399339.html" title="Set execution plan view options to specify defaults for viewing query plans.">Execution Plan View Options Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700400855.html" title="The general user preferences concern executing and debugging procedural objects.">Database Development General Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700404058.html" title="SQL Editor preferences define the behavior of the SQL File Editor.">SQL Editor Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700412058.html" title="The SQL Results view preferences determine the behavior of the SQL Results view.">SQL Results View Options Preferences</a></div> |
| </div> |
| </div> |
| <div/> |
| </body> |
| </html> |
