| <?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-us" xml:lang="en-us"> |
| <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="task"/> |
| <meta name="DC.Title" content="Editing a SQL File"/> |
| <meta name="abstract" content="Edit the SQL statements in a SQL file."/> |
| <meta name="description" content="Edit the SQL statements in a SQL file."/> |
| <meta name="DC.subject" content="dtp"/> |
| <meta name="keywords" content="dtp"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700452591.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700458544.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700459919.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700466482.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700453997.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700455575.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700404058.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700405683.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700407058.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700408496.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700409121.html"/> |
| <meta name="DC.Creator" content="ekapner"/> |
| <meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\workspace\dmp\en\source\t_editing_a_sql_file.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="t_438t836_1_761_5814_060606"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:27:36]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700456982"/> |
| <meta name="DC.Language" content="en-US"/> |
| <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">Editing a SQL File</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700456982"><a name="asc1229700456982"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1"> Editing a SQL File</h1> |
| |
| |
| |
| <div><p>Edit the SQL statements in a SQL file. |
| </p> |
| |
| <a name="asc1229700456982__steps_CB61EE72927840458C537D7EB1CBD65E"><!-- --></a><ol id="asc1229700456982__steps_CB61EE72927840458C537D7EB1CBD65E"> |
| <li class="stepexpand" id="asc1229700456982__step_27E92575D0A24A61A302D07FCBDA4732"><a name="asc1229700456982__step_27E92575D0A24A61A302D07FCBDA4732"><!-- --></a> |
| <span>In <span> |
| <span class="uicontrol">WorkSpace</span> |
| </span> |
| Navigator, double-click the SQL file to open it in SQL File Editor. |
| </span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700456982__step_10BFD42678674B13A3E2523C70C45995"><a name="asc1229700456982__step_10BFD42678674B13A3E2523C70C45995"><!-- --></a> |
| <span>(Optional) Change the connection profile <span class="uicontrol">Type</span>, <span class="uicontrol">Name</span>, and/or |
| <span class="uicontrol">Database</span>.</span> |
| |
| <p>Associating a SQL file with the connection profile of a connected |
| data server enables you to use the full capabilities of Content Assist and to |
| execute the SQL file or selected statements. |
| </p> |
| |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700456982__step_EC717501866B407E8D887B0BA368C168"><a name="asc1229700456982__step_EC717501866B407E8D887B0BA368C168"><!-- --></a> |
| <span>(Optional) Right-click in the left margin and select <span class="uicontrol">Show Line Numbers</span>.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700456982__step_61817BD6653A49CB9B07F06BB8E05FD1"><a name="asc1229700456982__step_61817BD6653A49CB9B07F06BB8E05FD1"><!-- --></a> |
| |
| <span>Edit the SQL file by manually editing the SQL code or by launching <span>Visual |
| SQL</span> |
| <span>SQL Query Builder</span>.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700456982__step_663B9F0829594864A584EAFD35DCE0A3"><a name="asc1229700456982__step_663B9F0829594864A584EAFD35DCE0A3"><!-- --></a> |
| <span>(Optional) Remove edits since your last save by right-clicking |
| and selecting <span class="uicontrol">Revert File</span>.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700456982__step_38CDF798424E48B290A2F7857CA6CB4B"><a name="asc1229700456982__step_38CDF798424E48B290A2F7857CA6CB4B"><!-- --></a> |
| <span>Save the file to the project or to a new project.</span> |
| </li> |
| |
| </ol> |
| |
| </div> |
| |
| <div><div class="relconcepts"><strong>Related concepts</strong><br/> |
| <div><a href="../../doc/html/asc1229700453997.html" title="Use the SQL File Editor to create and edit SQL statements.">SQL File Editor</a></div> |
| <div><a href="../../doc/html/asc1229700455575.html" title="SQL Scrapbook enables you to quickly create and execute SQL commands and queries, as well as procedural objects without creating a SQL file.">SQL Scrapbook</a></div> |
| </div> |
| <div class="reltasks"><strong>Related tasks</strong><br/> |
| <div><a href="../../doc/html/asc1229700452591.html" title="Use Database Development tools to create SQL files.">Creating a SQL File</a></div> |
| <div><a href="../../doc/html/asc1229700458544.html" title="Open a SQL file for viewing or editing in the SQL File Editor.">Opening a SQL File</a></div> |
| <div><a href="../../doc/html/asc1229700459919.html" title="Save one or more SQL files to the current project, or save a SQL file to a different project or to a different file name.">Saving a SQL File</a></div> |
| <div><a href="../../doc/html/asc1229700466482.html" title="You can execute a SQL file from the SQL File Editor or from WorkSpace Navigator.">Executing a SQL File</a></div> |
| </div> |
| <div class="relref"><strong>Related reference</strong><br/> |
| <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/asc1229700405683.html" title="SQL Editor Code Assist preferences define the behavior of the Code Assist feature in SQL File Editor.">Code Assist Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700407058.html" title="SQL files and scrapbooks preferences define the behavior of SQL files in SQL File Editor and SQL Scrapbook.">SQL Files/Scrapbooks Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700408496.html" title="Indicate your preferences for syntax coloring and text style for SQL source code in SQL Editor or SQL Scrapbook.">Syntax Coloring Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700409121.html" title="You can create new SQL templates and edit existing ones.">Templates Preferences</a></div> |
| </div> |
| </div> |
| <div/> |
| </body> |
| </html> |
