blob: e03268492f9dfe6298285778591a1ae693b4fdc4 [file] [log] [blame]
<?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="reference"/>
<meta name="DC.Title" content="Templates Preferences"/>
<meta name="abstract" content="You can create new SQL templates and edit existing ones."/>
<meta name="description" content="You can create new SQL templates and edit existing ones."/>
<meta name="DC.subject" content="sybase_workspace, database_development, dtp"/>
<meta name="keywords" content="sybase_workspace, database_development, dtp"/>
<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/asc1229700452591.html"/>
<meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700456982.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.Creator" content="ekapner"/>
<meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\workspace\ws\en\source\r_template_preferences.xml"/>
<meta name="DitaCms:MapImporter:OriginalObjectId" content="r_t42511t47_5r454r43c47_060606"/>
<meta name="status" content="Authoring:work"/>
<meta name="source" content="Map Importer"/>
<meta name="comment:user" content="updates for 2.1.2"/>
<meta name="DC.Format" content="XHTML"/>
<meta name="DC.Identifier" content="asc1229700409121"/>
<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">Templates Preferences</title>
<meta name="provider" content="Sybase, Inc."/></head>
<body id="asc1229700409121"><a name="asc1229700409121"><!-- --></a>
<br/>
<h1 class="topictitle1"> Templates Preferences</h1>
<div><p>You can create new SQL templates and edit existing ones.
</p>
<div class="section" id="asc1229700409121__section_E107A8479A3F436FABDC5A21F1A65B36"><a name="asc1229700409121__section_E107A8479A3F436FABDC5A21F1A65B36"><!-- --></a>
<p>Templates make code generation more convenient by allowing you to
insert frequently recurring source code patterns into your projects in SQL
Editor.
</p>
<div class="tablenoborder"><a name="asc1229700409121__table_15F665593F8D4F658049C67769FED8A1"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700409121__table_15F665593F8D4F658049C67769FED8A1" frame="border" border="1" rules="all"><caption><span class="tablecap">Table 1. SQL Editor templates</span></caption>
<thead align="left">
<tr>
<th class="cellrowborder" valign="top" width="33.33333333333333%" id="d1649e64">Field
</th>
<th class="cellrowborder" valign="top" width="66.66666666666666%" id="d1649e67">Description
</th>
</tr>
</thead>
<tbody>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> Create, Edit, or Remove Templates</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Displays the existing templates in your workspace. Displayed information includes the name, context, description, and status of the auto-insert attribute.</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> Preview
</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Click a template to display the first few lines of the SQL template in the Preview window. </td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> New
</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Create a new template. New templates are added to the list.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> Edit
</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Edit the selected template.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> Remove
</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Deletes all selected templates.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> Restore Removed
</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Restores removed default templates.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> Revert to Default
</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Reverts the selected template to its default state.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> Import
</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Imports templates into your workspace from the file
system.
</td>
</tr>
<tr>
<td class="cellrowborder" valign="top" width="33.33333333333333%" headers="d1649e64 "> Export
</td>
<td class="cellrowborder" valign="top" width="66.66666666666666%" headers="d1649e67 "> Exports all selected templates to a specified location
in the file system.
</td>
</tr>
</tbody>
</table>
</div>
</div>
</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/asc1229700456982.html" title="Edit the SQL statements in a SQL file.">Editing 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>
</div>
<div/>
</body>
</html>