About This Document
Who Should Read This Manual
For More Information
SQL Overview
Working with SQL in Zen
Data Definition Statements
Creating, Modifying, and Deleting Tables
Creating and Deleting Views
Creating and Deleting Indexes
Creating and Deleting Triggers
Creating and Deleting Stored Procedures
Creating and Deleting User-Defined Functions (UDF)
Data Manipulation Statements
Retrieving Data
Modifying Data
Creating and Deleting Views
Executing Stored Procedures
Executing System Stored Procedures
Executing Triggers
Data Control Statements
Enabling and Disabling Security
Creating and Deleting Users and Groups
Granting and Revoking Rights
Zen Metadata
Comparison of Metadata Versions
Relational Engine Limits
Fully Qualified Object Names
Delimited Identifiers in SQL Statements
Examples
SQL Syntax Reference
Literal Values
String Values
Examples
Number Values
Date Values
Examples
Time Values
Examples
Time Stamp Values
Examples
SQL Grammar in Zen
ADD
Remarks
See Also
ALL
Remarks
Examples
See Also
ALTER (rename)
Syntax
Remarks
Examples
See Also
ALTER GROUP
Syntax
Remarks
Examples
See Also
ALTER TABLE
Syntax
Remarks
IN DICTIONARY
USING
WITH REPLACE
MODIFY COLUMN and ALTER COLUMN
PSQL_MOVE
RENAME COLUMN
ON DELETE CASCADE
Examples
See Also
ALTER USER
Syntax
Remarks
Examples
See Also
ANY
Remarks
Examples
See Also
AS
Remarks
Examples
See Also
BEGIN [ATOMIC]
Remarks
Example
See Also
CALL
Remarks
Examples
See Also
CASCADE
Remarks
See Also
CASE (expression)
Syntax
Arguments
Remarks
Examples
See Also
CASE (string)
Remarks
Examples
See Also
CLOSE
Syntax
Remarks
Examples
See Also
COALESCE
Syntax
Returned Value Types
Restrictions
COALESCE Supported Combination Types and Result Data Types
Examples
COMMIT
Syntax
Examples
See Also
CREATE DATABASE
Syntax
Remarks
Database Name and IF NOT EXISTS Clause
Dictionary Path
Data Path
Referential Integrity
BOUND
Dictionary Files
Security
Metadata Version
Encoding
Valid Code Page Names and Numbers
Examples
See Also
CREATE FUNCTION
Syntax
Remarks
Restrictions
Limits
Supported Scalar Input Parameters and Returned Data Types
Examples
Invoking a Scalar User-Defined Function
Limits
Examples of User-Defined Functions
See Also
CREATE GROUP
Syntax
Remarks
Examples
See Also
CREATE INDEX
Syntax
Remarks
Index Segments
UNIQUE
PARTIAL
Limitations of PARTIAL
Examples
NOT MODIFIABLE
USING
IN DICTIONARY
Examples
See Also
CREATE PROCEDURE
Syntax
Remarks
Trusted and Non-Trusted Stored Procedures
Memory Caching
Caching Exclusions
Data Type Restrictions
Limits
Examples
Using Stored Procedures
General Stored Procedure Engine Limitations
Limits to SQL Variables and Parameters
Limits to Cursors
Limits when using Long Data
See Also
CREATE TABLE
Syntax
Remarks
Limitations on Record Size
Example of Limitation on Record Size
Delete Rule
Update Rule
IN DICTIONARY
USING
WITH REPLACE
DCOMPRESS
PCOMPRESS
PAGESIZE
LINKDUP
Examples
See Also
CREATE (temporary) TABLE
Syntax
Remarks
Compatibility with Previous Releases
TEMPDB Database
Table Names of Local Temporary Tables
Transactions
SELECT INTO
Restrictions on SELECT INTO
Caching of Stored Procedures
Examples of Temporary Tables
See Also
CREATE TRIGGER
Syntax
Remarks
Examples
See Also
CREATE USER
Syntax
Remarks
Examples
See Also
CREATE VIEW
Syntax
Remarks
ORDER BY
Trusted and Non-Trusted Views
Examples of Trusted and Non-Trusted Views
See Also
DECLARE
Remarks
Examples
See Also
DECLARE CURSOR
Syntax
Remarks
Examples
See Also
DEFAULT
Syntax
Remarks
Restrictions on Identity Data Types
Scalar Functions and Simple Expressions as Default Column Values
Using DEFAULT with ALTER TABLE
Examples
See Also
DELETE (positioned)
Syntax
Remarks
Examples
See Also
DELETE
Syntax
Remarks
FROM Clause
Examples
DISTINCT
Examples
See Also
DROP DATABASE
Syntax
Remarks
Secured Databases
DELETE FILES
Examples
See Also
DROP FUNCTION
Syntax
Remarks
Examples
See Also
DROP GROUP
Syntax
Remarks
Examples
See Also
DROP INDEX
Syntax
Remarks
Partial Indexes
Examples
See Also
DROP PROCEDURE
Syntax
Remarks
Examples
See Also
DROP TABLE
Syntax
Remarks
Examples
See Also
DROP TRIGGER
Syntax
Remarks
Examples
See Also
DROP USER
Syntax
Remarks
Examples
See Also
DROP VIEW
Syntax
Remarks
Examples
See Also
END
Remarks
EXECUTE
Syntax
Remarks
Examples
See Also
EXISTS
Syntax
Remarks
Examples
See Also
FETCH
Syntax
Remarks
Examples
See Also
FOREIGN KEY
Remarks
Examples
See Also
GRANT
Syntax
Remarks
GRANT LOGIN TO
Constraints on Permissions
By Object Type
Notes
ALL Keyword
Notes
GRANT and Data Security
Granting Permissions to Users and Groups
Granting Access Using Owner Names
Permissions on Views and Stored Procedures
Trusted and Non-Trusted Objects
Examples
See Also
GROUP BY
See Also
HAVING
Examples
See Also
IF
Syntax
Remarks
Examples
See Also
IN
Remarks
Examples
See Also
INSERT
Syntax
Remarks
INSERT ON DUPLICATE KEY UPDATE
Inserting Data Longer Than the Maximum Literal String
Examples
Examples for INSERT
Examples for INSERT ON DUPLICATE KEY UPDATE
Errors When Using DEFAULT
See Also
JOIN
Syntax
LEFT OUTER
Vendor Strings
Examples
Emp Table
Dept Table
Addr Table
Loc Table
Algorithm
See Also
LAG
Syntax
Examples
LEAVE
Remarks
Examples
See Also
LIKE, ILIKE, and Using ESCAPE
Syntax
Remarks
ESCAPE with Unicode
Examples of LIKE
Examples of ILIKE
Example of LIKE or ILIKE with ESCAPE
See Also
LOOP
Remarks
Examples
See Also
NOT
Remarks
Examples
See Also
OPEN
Syntax
Remarks
Examples
See Also
PARTIAL
Remarks
See Also
PRIMARY KEY
Remarks
Examples
See Also
PRINT
Remarks
Examples
See Also
PUBLIC
Remarks
Examples
See Also
RELEASE SAVEPOINT
Syntax
Remarks
Examples
See Also
RESTRICT
Remarks
See Also
REVOKE
Syntax
Examples
See Also
ROLLBACK
Syntax
Remarks
Examples
See Also
SAVEPOINT
Syntax
Remarks
Examples
See Also
SELECT
Syntax
Remarks
FOR UPDATE
Constraints
GROUP BY
SQL Windowing Functions
Limitations
Considerations
Dynamic Parameters
Aliases
SUM and DECIMAL Precision
Subqueries
Subquery Optimization
UNION in Subquery
Table Subqueries
Using Table Hints
Table Hint Restrictions
Accessing System Data v2
Examples
FOR UPDATE
FOR UPDATE
Approximate Numeric Literal
Between Predicate
Correlation Name
Exact Numeric Literal
In Predicate
Set Functions
Date Literal
Time Literal
Time Stamp Literal
String Literal
Date Arithmetic
IF
Multidatabase Join
Left Outer Join
Right Outer Join
Cartesian Join
Queries with Sys$create and Sys$update
DISTINCT in Aggregate Functions
TOP or LIMIT
Cursor Types and TOP or LIMIT
TOP or LIMIT Examples
Table Hint Examples
See Also
SELECT (with INTO)
Syntax
Remarks
Examples
See Also
SET
Syntax
Remarks
Examples
See Also
SET ANSI_PADDING
Syntax
Remarks
Restrictions
Examples
See Also
SET CACHED_PROCEDURES
Syntax
Remarks
Registry Setting
Caching Exclusions
Examples
See Also
SET DECIMALSEPARATORCOMMA
Syntax
Remarks
Examples
See Also
SET DEFAULTCOLLATE
Syntax
Remarks
Using ACS Files
Using ISR Table Names
ACS, ISR, and ICU Examples
See Also
SET LEGACYTYPESALLOWED
Syntax
Remarks
Example
SET OWNER
Syntax
Remarks
Examples
See Also
SET PASSWORD
Syntax
Remarks
Password Characteristics
Examples
See Also
SET PROCEDURES_CACHE
Syntax
Remarks
Registry Setting
Caching Exclusions
Examples
See Also
SET ROWCOUNT
Syntax
Remarks
Examples
See Also
SET SECURITY
Syntax
Remarks
User Permissions
Examples
See Also
SET TIME ZONE
Syntax
Remarks
A Note about Time Stamp Data Types
Examples
See Also
SET TRUEBITCREATE
Syntax
Remarks
Example
SET TRUENULLCREATE
Syntax
Remarks
Examples
SIGNAL
Remarks
Syntax
Examples
See Also
SQLSTATE
Remarks
See Also
START TRANSACTION
Syntax
Remarks
Examples
See Also
UNION
Remarks
Examples
See Also
UNIQUE
Remarks
See Also
UNMASK
UPDATE
Syntax
Remarks
Updating Data Longer Than the Maximum Literal String
FROM Clause
Examples
See Also
UPDATE (positioned)
Syntax
Remarks
Examples
See Also
USER
Remarks
Example
See Also
WHILE
Syntax
Remarks
Examples
See Also
Grammar Element Definitions
SQL Statement List
Predicate
Expression
Global Variables
@@IDENTITY and @@BIGIDENTITY
Examples
@@ROWCOUNT
Examples
@@SESSIONID
Example
@@SPID
Example
@@VERSION
Example
Other Characteristics
Temporary Files
When Are Temporary Files Created?
In-Memory Temporary File
On-Disk Temporary File
Btrieve Temporary File
Working with NULL Values
Working with Binary Data
Creating Indexes
Comma as Decimal Separator
Client-Server Considerations
Changing the Locale Setting
Examples
Example A – Server locale uses a comma for decimal separator
Example B – Server locale uses the period for decimal separator
Scalar Functions
Bitwise Operators
Truth Table
Arithmetic Operators
Date Arithmetic
Example
String Functions
Examples
Numeric Functions
Examples
Time and Date Functions
Time and Date Function Examples
System Functions
System Function Examples
Logical Functions
Logical Function Examples
Conversion Functions
Conversion Function Examples
System Stored Procedures
Zen System Stored Procedures
psp_columns
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Result Set
Error Conditions
psp_column_attributes
Syntax
Arguments
Returned Result Set
Examples
Result Set
Result Set
Result Set
Error Conditions
psp_column_rights
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Result Set
Result Set
Error Conditions
psp_dbnames
Syntax
Arguments
Returned Result Set
Example
psp_fkeys
Syntax
Arguments
Returned Result Set
Example
Result Set
Error Conditions
psp_groups
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
psp_help_sp
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
psp_help_trigger
Syntax
Arguments
Returned Result Set
Example
Result Set
Error Conditions
psp_help_udf
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
psp_help_view
Syntax
Arguments
Returned Result Set
Example
Result Set
Error Conditions
psp_indexes
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
psp_pkeys
Syntax
Arguments
Returned Result Set
Example
Result Set
Error Conditions
psp_procedure_rights
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
psp_rename
Syntax
Arguments
Example
Error Conditions
psp_stored_procedures
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
psp_tables
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Result Set
Error Conditions
psp_table_rights
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
psp_triggers
Syntax
Arguments
Returned Result Set
Example
Result Set
Error Conditions
psp_udfs
Syntax
Arguments
Returned Result Set
Example
Result Set
Error Conditions
psp_users
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
psp_view_rights
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Result Set
Error Conditions
psp_views
Syntax
Arguments
Returned Result Set
Example
Result Set
Result Set
Error Conditions
Performance Optimization Reference
Restriction Analysis
Modified CNF Conversion
Restrictions that Cannot be Converted
Conditions Under Which Conversion is Avoided
Restriction Optimization
Single Predicate Optimization
Closed Range Optimization
Modified Disjunct Optimization
Conjunct Optimization
Disjunctive Normal Form Optimization
Modified Conjunctive Normal Form Optimization
Closing Open-Ended Ranges through Modified CNF Optimization
Single Join Condition Optimization
Conjunct with Join Conditions Optimization
Modified Conjunctive Normal Form with Join Conditions Optimization
Closing Join Condition Open-Ended Ranges through Modified CNF Optimization
Multi-Index Modified Disjunct Optimization
Push-Down Filters
Efficient Use of Indexes
DISTINCT in Aggregate Functions
DISTINCT Preceding Selection List
Relaxed Index Segment Order Sensitivity
Relaxed Segment Ascending Attribute Sensitivity
Search Update Optimization
Temporary Table Performance
Row Prefetch
Terminology
Aggregate Function
Closed Range
Conjunct
Conjunctive Normal Form (CNF)
Disjunct
Disjunctive Normal Form (DNF)
Expression
Index
Join Condition
Leading Segments
Modified Conjunctive Normal Form (Modified CNF)
Modified Disjunct
Open-Ended Range
Predicate
Restriction
System Catalog Functions
Zen System Catalog Functions
Return Status
Summary
dbo.fSQLColumns
Syntax
Arguments
Returned Result Set
Example
dbo.fSQLForeignKeys
Syntax
Arguments
Returned Result Set
Example
dbo.fSQLPrimaryKeys
Syntax
Arguments
Returned Result Set
Example
dbo.fSQLProcedures
Syntax
Arguments
Returned Result Set
Example
dbo.fSQLProcedureColumns
Syntax
Arguments
Returned Result Set
Example
dbo.fSQLSpecialColumns
Syntax
Arguments
Returned Result Set
Example
dbo.fSQLStatistics
Syntax
Arguments
Returned Result Set
Example
dbo.fSQLTables
Syntax
Arguments
Returned Result Set
Example
dbo.fSQLDBTableStat
Syntax
Argument
Returned Result Set
Example
String Search Patterns
Examples
Vector Collection Functions
Return Status
Return Status
Notes about Vector Collection Functions
About the Examples
dbo.vector_collection_create
Syntax
Arguments
Results
Example
dbo.vector_collection_drop
Syntax
Arguments
Results
Example
dbo.vector_point_upsert
Syntax
Arguments
Examples
dbo.vector_point_upsert_batch
Syntax
Arguments
Examples
dbo.vector_point_delete
Syntax
Arguments
Examples
dbo.vector_point_delete_batch
Syntax
Arguments
Example
dbo.vector_collection_search
Syntax
Arguments
Results
Examples
Result Set
Result Set
A. Data Types
Zen Supported Data Types
Data Type Ranges
Operator Precedence
Parentheses
Data Type Precedence
Numeric Data Types
Character Data Types
Data Types with No Precedence
Precision and Scale of Decimal Data Types
Scale of Time Stamp Data Types and Returned Function Values
Truncation
Notes on Data Types
CHAR, NCHAR, VARCHAR, NVARCHAR, LONGVARCHAR, and NLONGVARCHAR
BINARY and LONGVARBINARY
Limitations on LONGVARCHAR, NLONGVARCHAR and LONGVARBINARY
DATETIME
Format of DATETIME
Compatibility of Date and Time Data Types
UNIQUEIDENTIFIER
Declaring Variables
Converting UNIQUEIDENTIFIER to Another Data Type
Representation of Infinity
Legacy Data Types
Btrieve Key Data Types
AUTOINCREMENT
Restrictions
AUTOTIMESTAMP
Inserts and Updates Using AUTOTIMESTAMP
Restrictions
Usage in Function Executor and Maintenance Tools
BFLOAT
STRING
CURRENCY
DATE
DECIMAL
Windows
Linux
FLOAT
GUID
GUID Keys
INTEGER
LOGICAL
LSTRING
MONEY
NUMERIC
Enabling the Shifted Format
Windows 32-Bit
Linux
Consistent Sign Values for Positive NUMERIC Data
NUMERICSA
NUMERICSLB
NUMERICSLS
NUMERICSTB
NUMERICSTS
TIME
TIMESTAMP
Usage in Function Executor and Maintenance Tools
TIMESTAMP2
Usage in Function Executor and Maintenance Tools
UNSIGNED BINARY
WSTRING
WZSTRING
ZSTRING
Non-Key Data Types
BLOB
CLOB
B. SQL Reserved Words
Reserved Words
Symbols
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Words to Avoid
C. System Tables
Overview
System Tables Structure
V1 Metadata System Tables
X$Attrib
X$Depend
X$Field
X$File
X$Index
X$Proc
X$Relate
X$Rights
X$Trigger
X$User
X$View
V2 Metadata System Tables
X$Attrib
X$Depend
X$Field
X$File
X$Index
X$Proc
X$Relate
X$Rights
X$Trigger
X$User
X$View
D. SQL Access for COBOL Applications
Overview of Zen Support for COBOL
Restrictions
SQL Statements
Components
Using SQL Access
Step 1: Modify the Sample XML Templates
Step 2: Copy the Data File Specified in the XML Template
Step 3: Run the Schema Executor Utility
Schema Executor Command Format
Example Usage
Creating a New Database with Schema Executor
Log Messages
Step 4: Optionally, Deploy the System Tables
Example of How to Execute a Sample XML File
Additional Notes
SELECT Statements
Table Filters
Examples of Valid TABLEFILTER Usage
E. Query Plan Viewer
Query Plan Settings
Graphical User Interface
Query Viewer
Plan Viewer
Nodes
Node Details
Query Plan Viewer Tasks
SET QRYPLAN Method
Log Query Plan Method
Examining Query Plans and Evaluating Query Performance
Creating Example Query Plans for Comparison
Viewing the Example Query Plans
About This Document
SQL Overview
SQL Syntax Reference
Scalar Functions
System Stored Procedures
Performance Optimization Reference
System Catalog Functions
Vector Collection Functions
A. Data Types
B. SQL Reserved Words
C. System Tables
D. SQL Access for COBOL Applications
E. Query Plan Viewer
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
About This Document
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
About This Document
>
Who Should Read This Manual
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
About This Document
>
For More Information
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Definition Statements
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Definition Statements
>
Creating, Modifying, and Deleting Tables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Definition Statements
>
Creating and Deleting Views
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Definition Statements
>
Creating and Deleting Indexes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Definition Statements
>
Creating and Deleting Triggers
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Definition Statements
>
Creating and Deleting Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Definition Statements
>
Creating and Deleting User-Defined Functions (UDF)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Manipulation Statements
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Manipulation Statements
>
Retrieving Data
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Manipulation Statements
>
Modifying Data
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Manipulation Statements
>
Creating and Deleting Views
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Manipulation Statements
>
Executing Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Manipulation Statements
>
Executing System Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Manipulation Statements
>
Executing Triggers
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Control Statements
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Control Statements
>
Enabling and Disabling Security
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Control Statements
>
Creating and Deleting Users and Groups
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Working with SQL in Zen
>
Data Control Statements
>
Granting and Revoking Rights
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Zen Metadata
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Zen Metadata
>
Comparison of Metadata Versions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Relational Engine Limits
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Relational Engine Limits
>
Fully Qualified Object Names
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Relational Engine Limits
>
Delimited Identifiers in SQL Statements
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Overview
>
Relational Engine Limits
>
Delimited Identifiers in SQL Statements
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
String Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
Number Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
Date Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
Time Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
Time Stamp Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Literal Values
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SQL Grammar in Zen
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ADD
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ADD
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ADD
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALL
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALL
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALL
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER (rename)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER (rename)
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER (rename)
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER (rename)
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER (rename)
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER GROUP
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER GROUP
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER GROUP
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER GROUP
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER GROUP
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
IN DICTIONARY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
USING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
WITH REPLACE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
MODIFY COLUMN and ALTER COLUMN
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
PSQL_MOVE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
RENAME COLUMN
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
ON DELETE CASCADE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER TABLE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER USER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER USER
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER USER
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER USER
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ALTER USER
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ANY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ANY
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ANY
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ANY
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
AS
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
AS
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
AS
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
AS
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
BEGIN [ATOMIC]
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
BEGIN [ATOMIC]
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
BEGIN [ATOMIC]
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
BEGIN [ATOMIC]
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CALL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CALL
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CALL
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CALL
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASCADE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASCADE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASCADE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (expression)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (expression)
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (expression)
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (expression)
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (expression)
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (expression)
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (string)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (string)
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (string)
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CASE (string)
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CLOSE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CLOSE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CLOSE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CLOSE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CLOSE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COALESCE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COALESCE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COALESCE
>
Returned Value Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COALESCE
>
Restrictions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COALESCE
>
COALESCE Supported Combination Types and Result Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COALESCE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COMMIT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COMMIT
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COMMIT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
COMMIT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Database Name and IF NOT EXISTS Clause
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Dictionary Path
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Data Path
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Referential Integrity
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
BOUND
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Dictionary Files
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Security
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Metadata Version
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Encoding
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Encoding
>
Valid Code Page Names and Numbers
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE DATABASE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Restrictions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Limits
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Supported Scalar Input Parameters and Returned Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Invoking a Scalar User-Defined Function
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Limits
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
Examples of User-Defined Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE FUNCTION
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE GROUP
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE GROUP
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE GROUP
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE GROUP
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE GROUP
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
Index Segments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
UNIQUE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
PARTIAL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
PARTIAL
>
Limitations of PARTIAL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
NOT MODIFIABLE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
USING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
IN DICTIONARY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE INDEX
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Trusted and Non-Trusted Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Memory Caching
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Memory Caching
>
Caching Exclusions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Data Type Restrictions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Limits
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Using Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
General Stored Procedure Engine Limitations
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Limits to SQL Variables and Parameters
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Limits to Cursors
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
Limits when using Long Data
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE PROCEDURE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
Limitations on Record Size
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
Limitations on Record Size
>
Example of Limitation on Record Size
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
Delete Rule
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
Update Rule
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
IN DICTIONARY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
USING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
WITH REPLACE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
DCOMPRESS
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
PCOMPRESS
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
PAGESIZE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
LINKDUP
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TABLE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
Compatibility with Previous Releases
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
TEMPDB Database
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
Table Names of Local Temporary Tables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
Transactions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
SELECT INTO
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
Restrictions on SELECT INTO
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
Caching of Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
Examples of Temporary Tables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE (temporary) TABLE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TRIGGER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TRIGGER
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TRIGGER
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TRIGGER
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE TRIGGER
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE USER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE USER
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE USER
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE USER
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE USER
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE VIEW
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE VIEW
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE VIEW
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE VIEW
>
ORDER BY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE VIEW
>
Trusted and Non-Trusted Views
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE VIEW
>
Examples of Trusted and Non-Trusted Views
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
CREATE VIEW
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE CURSOR
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE CURSOR
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE CURSOR
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE CURSOR
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DECLARE CURSOR
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DEFAULT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DEFAULT
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DEFAULT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DEFAULT
>
Remarks
>
Restrictions on Identity Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DEFAULT
>
Remarks
>
Scalar Functions and Simple Expressions as Default Column Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DEFAULT
>
Remarks
>
Using DEFAULT with ALTER TABLE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DEFAULT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DEFAULT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE (positioned)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE (positioned)
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE (positioned)
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE (positioned)
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE (positioned)
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE
>
FROM Clause
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DELETE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DISTINCT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DISTINCT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DISTINCT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP DATABASE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP DATABASE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP DATABASE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP DATABASE
>
Secured Databases
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP DATABASE
>
DELETE FILES
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP DATABASE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP DATABASE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP FUNCTION
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP FUNCTION
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP FUNCTION
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP FUNCTION
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP FUNCTION
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP GROUP
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP GROUP
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP GROUP
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP GROUP
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP GROUP
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP INDEX
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP INDEX
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP INDEX
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP INDEX
>
Partial Indexes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP INDEX
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP INDEX
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP PROCEDURE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP PROCEDURE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP PROCEDURE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP PROCEDURE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP PROCEDURE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TABLE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TABLE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TABLE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TABLE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TABLE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TRIGGER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TRIGGER
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TRIGGER
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TRIGGER
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP TRIGGER
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP USER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP USER
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP USER
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP USER
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP USER
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP VIEW
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP VIEW
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP VIEW
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP VIEW
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
DROP VIEW
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
END
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
END
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXECUTE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXECUTE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXECUTE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXECUTE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXECUTE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXISTS
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXISTS
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXISTS
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXISTS
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
EXISTS
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FETCH
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FETCH
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FETCH
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FETCH
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FETCH
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FOREIGN KEY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FOREIGN KEY
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FOREIGN KEY
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
FOREIGN KEY
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
GRANT LOGIN TO
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Constraints on Permissions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Constraints on Permissions
>
By Object Type
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Constraints on Permissions
>
By Object Type
>
Notes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Constraints on Permissions
>
ALL Keyword
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Constraints on Permissions
>
ALL Keyword
>
Notes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
GRANT and Data Security
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
GRANT and Data Security
>
Granting Permissions to Users and Groups
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
GRANT and Data Security
>
Granting Access Using Owner Names
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Permissions on Views and Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Permissions on Views and Stored Procedures
>
Trusted and Non-Trusted Objects
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GRANT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GROUP BY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
GROUP BY
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
HAVING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
HAVING
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
HAVING
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IF
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IF
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IF
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IF
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IF
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IN
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IN
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IN
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
IN
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
INSERT ON DUPLICATE KEY UPDATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
Inserting Data Longer Than the Maximum Literal String
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
Examples for INSERT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
Examples for INSERT ON DUPLICATE KEY UPDATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
Errors When Using DEFAULT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
INSERT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Syntax
>
LEFT OUTER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Syntax
>
Vendor Strings
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Examples
>
Emp Table
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Examples
>
Dept Table
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Examples
>
Addr Table
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Examples
>
Loc Table
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
Examples
>
Loc Table
>
Algorithm
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
JOIN
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LAG
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LAG
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LAG
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LEAVE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LEAVE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LEAVE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LEAVE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LIKE, ILIKE, and Using ESCAPE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LIKE, ILIKE, and Using ESCAPE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LIKE, ILIKE, and Using ESCAPE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LIKE, ILIKE, and Using ESCAPE
>
ESCAPE with Unicode
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LIKE, ILIKE, and Using ESCAPE
>
Examples of LIKE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LIKE, ILIKE, and Using ESCAPE
>
Examples of ILIKE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LIKE, ILIKE, and Using ESCAPE
>
Example of LIKE or ILIKE with ESCAPE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LIKE, ILIKE, and Using ESCAPE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LOOP
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LOOP
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LOOP
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
LOOP
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
NOT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
NOT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
NOT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
NOT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
OPEN
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
OPEN
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
OPEN
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
OPEN
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
OPEN
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PARTIAL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PARTIAL
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PARTIAL
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PRIMARY KEY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PRIMARY KEY
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PRIMARY KEY
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PRIMARY KEY
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PRINT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PRINT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PRINT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PRINT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PUBLIC
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PUBLIC
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PUBLIC
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
PUBLIC
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
RELEASE SAVEPOINT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
RELEASE SAVEPOINT
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
RELEASE SAVEPOINT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
RELEASE SAVEPOINT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
RELEASE SAVEPOINT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
RESTRICT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
RESTRICT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
RESTRICT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
REVOKE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
REVOKE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
REVOKE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
REVOKE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ROLLBACK
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ROLLBACK
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ROLLBACK
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ROLLBACK
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
ROLLBACK
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SAVEPOINT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SAVEPOINT
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SAVEPOINT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SAVEPOINT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SAVEPOINT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
FOR UPDATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
FOR UPDATE
>
Constraints
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
GROUP BY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
SQL Windowing Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
SQL Windowing Functions
>
Limitations
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
SQL Windowing Functions
>
Considerations
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Dynamic Parameters
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Aliases
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
SUM and DECIMAL Precision
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Subqueries
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Subqueries
>
Subquery Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Subqueries
>
UNION in Subquery
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Subqueries
>
Table Subqueries
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Using Table Hints
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Using Table Hints
>
Table Hint Restrictions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Remarks
>
Accessing System Data v2
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
FOR UPDATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Approximate Numeric Literal
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Between Predicate
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Correlation Name
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Exact Numeric Literal
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
In Predicate
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Set Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Date Literal
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Time Literal
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Time Stamp Literal
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
String Literal
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Date Arithmetic
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
IF
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Multidatabase Join
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Left Outer Join
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Right Outer Join
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Cartesian Join
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
FOR UPDATE
>
Queries with Sys$create and Sys$update
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
DISTINCT in Aggregate Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
TOP or LIMIT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
TOP or LIMIT
>
Cursor Types and TOP or LIMIT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
TOP or LIMIT
>
TOP or LIMIT Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
Examples
>
Table Hint Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT (with INTO)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT (with INTO)
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT (with INTO)
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT (with INTO)
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SELECT (with INTO)
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ANSI_PADDING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ANSI_PADDING
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ANSI_PADDING
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ANSI_PADDING
>
Restrictions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ANSI_PADDING
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ANSI_PADDING
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET CACHED_PROCEDURES
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET CACHED_PROCEDURES
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET CACHED_PROCEDURES
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET CACHED_PROCEDURES
>
Remarks
>
Registry Setting
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET CACHED_PROCEDURES
>
Remarks
>
Caching Exclusions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET CACHED_PROCEDURES
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET CACHED_PROCEDURES
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DECIMALSEPARATORCOMMA
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DECIMALSEPARATORCOMMA
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DECIMALSEPARATORCOMMA
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DECIMALSEPARATORCOMMA
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DECIMALSEPARATORCOMMA
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DEFAULTCOLLATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DEFAULTCOLLATE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DEFAULTCOLLATE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DEFAULTCOLLATE
>
Remarks
>
Using ACS Files
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DEFAULTCOLLATE
>
Remarks
>
Using ISR Table Names
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DEFAULTCOLLATE
>
ACS, ISR, and ICU Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET DEFAULTCOLLATE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET LEGACYTYPESALLOWED
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET LEGACYTYPESALLOWED
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET LEGACYTYPESALLOWED
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET LEGACYTYPESALLOWED
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET OWNER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET OWNER
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET OWNER
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET OWNER
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET OWNER
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PASSWORD
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PASSWORD
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PASSWORD
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PASSWORD
>
Remarks
>
Password Characteristics
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PASSWORD
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PASSWORD
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PROCEDURES_CACHE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PROCEDURES_CACHE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PROCEDURES_CACHE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PROCEDURES_CACHE
>
Remarks
>
Registry Setting
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PROCEDURES_CACHE
>
Remarks
>
Caching Exclusions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PROCEDURES_CACHE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET PROCEDURES_CACHE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ROWCOUNT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ROWCOUNT
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ROWCOUNT
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ROWCOUNT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET ROWCOUNT
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET SECURITY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET SECURITY
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET SECURITY
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET SECURITY
>
Remarks
>
User Permissions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET SECURITY
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET SECURITY
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TIME ZONE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TIME ZONE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TIME ZONE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TIME ZONE
>
Remarks
>
A Note about Time Stamp Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TIME ZONE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TIME ZONE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TRUEBITCREATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TRUEBITCREATE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TRUEBITCREATE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TRUEBITCREATE
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TRUENULLCREATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TRUENULLCREATE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TRUENULLCREATE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SET TRUENULLCREATE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SIGNAL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SIGNAL
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SIGNAL
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SIGNAL
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SIGNAL
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SQLSTATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SQLSTATE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
SQLSTATE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
START TRANSACTION
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
START TRANSACTION
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
START TRANSACTION
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
START TRANSACTION
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
START TRANSACTION
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UNION
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UNION
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UNION
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UNION
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UNIQUE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UNIQUE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UNIQUE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UNMASK
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE
>
Updating Data Longer Than the Maximum Literal String
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE
>
Updating Data Longer Than the Maximum Literal String
>
FROM Clause
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE (positioned)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE (positioned)
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE (positioned)
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE (positioned)
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
UPDATE (positioned)
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
USER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
USER
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
USER
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
USER
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
WHILE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
WHILE
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
WHILE
>
Remarks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
WHILE
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
WHILE
>
See Also
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Grammar Element Definitions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Grammar Element Definitions
>
SQL Statement List
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Grammar Element Definitions
>
Predicate
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Grammar Element Definitions
>
Expression
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@IDENTITY and @@BIGIDENTITY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@IDENTITY and @@BIGIDENTITY
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@ROWCOUNT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@ROWCOUNT
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@SESSIONID
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@SESSIONID
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@SPID
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@SPID
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@VERSION
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Global Variables
>
@@VERSION
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Temporary Files
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Temporary Files
>
When Are Temporary Files Created?
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Temporary Files
>
When Are Temporary Files Created?
>
In-Memory Temporary File
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Temporary Files
>
When Are Temporary Files Created?
>
On-Disk Temporary File
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Temporary Files
>
When Are Temporary Files Created?
>
Btrieve Temporary File
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Working with NULL Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Working with Binary Data
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Creating Indexes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Comma as Decimal Separator
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Comma as Decimal Separator
>
Client-Server Considerations
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Comma as Decimal Separator
>
Changing the Locale Setting
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Examples
>
Example A – Server locale uses a comma for decimal separator
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
SQL Syntax Reference
>
Other Characteristics
>
Examples
>
Example B – Server locale uses the period for decimal separator
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Bitwise Operators
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Bitwise Operators
>
Truth Table
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Arithmetic Operators
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Arithmetic Operators
>
Date Arithmetic
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Arithmetic Operators
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
String Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
String Functions
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Numeric Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Numeric Functions
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Time and Date Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Time and Date Functions
>
Time and Date Function Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
System Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
System Functions
>
System Function Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Logical Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Logical Functions
>
Logical Function Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Conversion Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Scalar Functions
>
Conversion Functions
>
Conversion Function Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_columns
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_attributes
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Example
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Example
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Example
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_column_rights
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_dbnames
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_dbnames
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_dbnames
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_dbnames
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_dbnames
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_fkeys
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_fkeys
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_fkeys
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_fkeys
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_fkeys
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_fkeys
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_fkeys
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_groups
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_groups
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_groups
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_groups
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_groups
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_groups
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_groups
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_groups
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_sp
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_sp
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_sp
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_sp
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_sp
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_sp
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_sp
>
Result Set
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_sp
>
Result Set
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_trigger
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_trigger
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_trigger
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_trigger
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_trigger
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_trigger
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_trigger
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_udf
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_udf
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_udf
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_udf
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_udf
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_udf
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_udf
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_udf
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_view
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_view
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_view
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_view
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_view
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_view
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_help_view
>
Result Set
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_indexes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_indexes
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_indexes
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_indexes
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_indexes
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_indexes
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_indexes
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_indexes
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_pkeys
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_pkeys
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_pkeys
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_pkeys
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_pkeys
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_pkeys
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_pkeys
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_procedure_rights
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_procedure_rights
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_procedure_rights
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_procedure_rights
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_procedure_rights
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_procedure_rights
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_procedure_rights
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_procedure_rights
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_rename
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_rename
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_rename
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_rename
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_rename
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_stored_procedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_stored_procedures
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_stored_procedures
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_stored_procedures
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_stored_procedures
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_stored_procedures
>
Example
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_stored_procedures
>
Example
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_stored_procedures
>
Example
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_tables
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_table_rights
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_table_rights
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_table_rights
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_table_rights
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_table_rights
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_table_rights
>
Example
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_table_rights
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_table_rights
>
Result Set
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_triggers
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_triggers
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_triggers
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_triggers
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_triggers
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_triggers
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_triggers
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_udfs
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_udfs
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_udfs
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_udfs
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_udfs
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_udfs
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_udfs
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_users
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_users
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_users
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_users
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_users
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_users
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_users
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_users
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_view_rights
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_views
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_views
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_views
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_views
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_views
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_views
>
Example
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_views
>
Example
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Stored Procedures
>
Zen System Stored Procedures
>
psp_views
>
Example
>
Error Conditions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Analysis
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Analysis
>
Modified CNF Conversion
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Analysis
>
Restrictions that Cannot be Converted
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Analysis
>
Conditions Under Which Conversion is Avoided
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Single Predicate Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Closed Range Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Modified Disjunct Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Conjunct Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Disjunctive Normal Form Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Modified Conjunctive Normal Form Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Closing Open-Ended Ranges through Modified CNF Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Single Join Condition Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Conjunct with Join Conditions Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Modified Conjunctive Normal Form with Join Conditions Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Closing Join Condition Open-Ended Ranges through Modified CNF Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Restriction Optimization
>
Multi-Index Modified Disjunct Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Push-Down Filters
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Efficient Use of Indexes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Efficient Use of Indexes
>
DISTINCT in Aggregate Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Efficient Use of Indexes
>
DISTINCT Preceding Selection List
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Efficient Use of Indexes
>
Relaxed Index Segment Order Sensitivity
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Efficient Use of Indexes
>
Relaxed Segment Ascending Attribute Sensitivity
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Efficient Use of Indexes
>
Search Update Optimization
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Temporary Table Performance
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Row Prefetch
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Aggregate Function
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Closed Range
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Conjunct
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Conjunctive Normal Form (CNF)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Disjunct
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Disjunctive Normal Form (DNF)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Expression
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Index
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Join Condition
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Leading Segments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Modified Conjunctive Normal Form (Modified CNF)
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Modified Disjunct
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Open-Ended Range
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Predicate
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Performance Optimization Reference
>
Terminology
>
Restriction
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
Zen System Catalog Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
Zen System Catalog Functions
>
Return Status
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
Zen System Catalog Functions
>
Summary
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLColumns
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLColumns
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLColumns
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLColumns
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLColumns
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLForeignKeys
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLForeignKeys
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLForeignKeys
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLForeignKeys
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLForeignKeys
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLPrimaryKeys
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLPrimaryKeys
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLPrimaryKeys
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLPrimaryKeys
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLPrimaryKeys
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedures
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedures
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedures
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedures
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedures
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedureColumns
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedureColumns
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedureColumns
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedureColumns
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLProcedureColumns
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLSpecialColumns
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLSpecialColumns
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLSpecialColumns
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLSpecialColumns
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLSpecialColumns
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLStatistics
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLStatistics
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLStatistics
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLStatistics
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLStatistics
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLTables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLTables
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLTables
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLTables
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLTables
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLDBTableStat
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLDBTableStat
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLDBTableStat
>
Argument
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLDBTableStat
>
Returned Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
dbo.fSQLDBTableStat
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
String Search Patterns
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
System Catalog Functions
>
String Search Patterns
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
Return Status
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
Return Status
>
Return Status
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
Return Status
>
Notes about Vector Collection Functions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
Return Status
>
About the Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_create
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_create
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_create
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_create
>
Results
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_create
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_drop
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_drop
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_drop
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_drop
>
Results
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_drop
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_upsert
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_upsert
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_upsert
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_upsert
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_upsert_batch
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_upsert_batch
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_upsert_batch
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_upsert_batch
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_delete
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_delete
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_delete
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_delete
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_delete_batch
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_delete_batch
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_delete_batch
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_point_delete_batch
>
Example
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_search
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_search
>
Syntax
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_search
>
Arguments
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_search
>
Results
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_search
>
Examples
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_search
>
Examples
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
Vector Collection Functions
>
dbo.vector_collection_search
>
Examples
>
Result Set
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Data Type Ranges
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Operator Precedence
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Operator Precedence
>
Parentheses
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Data Type Precedence
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Data Type Precedence
>
Numeric Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Data Type Precedence
>
Character Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Data Type Precedence
>
Data Types with No Precedence
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Precision and Scale of Decimal Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Scale of Time Stamp Data Types and Returned Function Values
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Zen Supported Data Types
>
Truncation
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
CHAR, NCHAR, VARCHAR, NVARCHAR, LONGVARCHAR, and NLONGVARCHAR
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
BINARY and LONGVARBINARY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
Limitations on LONGVARCHAR, NLONGVARCHAR and LONGVARBINARY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
DATETIME
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
DATETIME
>
Format of DATETIME
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
DATETIME
>
Compatibility of Date and Time Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
UNIQUEIDENTIFIER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
UNIQUEIDENTIFIER
>
Declaring Variables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
UNIQUEIDENTIFIER
>
Converting UNIQUEIDENTIFIER to Another Data Type
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Notes on Data Types
>
Representation of Infinity
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Legacy Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
AUTOINCREMENT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
AUTOINCREMENT
>
Restrictions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
AUTOTIMESTAMP
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
AUTOTIMESTAMP
>
Inserts and Updates Using AUTOTIMESTAMP
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
AUTOTIMESTAMP
>
Restrictions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
AUTOTIMESTAMP
>
Usage in Function Executor and Maintenance Tools
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
BFLOAT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
STRING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
CURRENCY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
DATE
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
DECIMAL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
DECIMAL
>
Windows
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
DECIMAL
>
Linux
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
FLOAT
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
GUID
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
GUID
>
GUID Keys
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
INTEGER
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
LOGICAL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
LSTRING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
MONEY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERIC
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERIC
>
Enabling the Shifted Format
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERIC
>
Enabling the Shifted Format
>
Windows 32-Bit
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERIC
>
Enabling the Shifted Format
>
Linux
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERIC
>
Consistent Sign Values for Positive NUMERIC Data
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERICSA
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERICSLB
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERICSLS
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERICSTB
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
NUMERICSTS
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
TIME
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
TIMESTAMP
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
TIMESTAMP
>
Usage in Function Executor and Maintenance Tools
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
TIMESTAMP2
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
TIMESTAMP2
>
Usage in Function Executor and Maintenance Tools
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
UNSIGNED BINARY
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
WSTRING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
WZSTRING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Btrieve Key Data Types
>
ZSTRING
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Non-Key Data Types
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Non-Key Data Types
>
BLOB
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
A. Data Types
>
Non-Key Data Types
>
CLOB
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
Symbols
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
A
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
B
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
C
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
D
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
E
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
F
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
G
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
H
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
I
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
J
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
K
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
L
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
M
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
N
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
O
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
P
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
Q
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
R
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
S
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
T
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
U
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
V
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Reserved Words
>
W
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
B. SQL Reserved Words
>
Words to Avoid
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
Overview
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$Attrib
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$Depend
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$Field
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$File
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$Index
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$Proc
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$Relate
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$Rights
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$Trigger
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$User
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V1 Metadata System Tables
>
X$View
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$Attrib
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$Depend
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$Field
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$File
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$Index
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$Proc
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$Relate
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$Rights
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$Trigger
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$User
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
C. System Tables
>
System Tables Structure
>
V2 Metadata System Tables
>
X$View
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Overview of Zen Support for COBOL
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Overview of Zen Support for COBOL
>
Restrictions
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Overview of Zen Support for COBOL
>
SQL Statements
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Components
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
>
Step 1: Modify the Sample XML Templates
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
>
Step 2: Copy the Data File Specified in the XML Template
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
>
Step 3: Run the Schema Executor Utility
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
>
Step 3: Run the Schema Executor Utility
>
Schema Executor Command Format
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
>
Step 3: Run the Schema Executor Utility
>
Schema Executor Command Format
>
Example Usage
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
>
Step 3: Run the Schema Executor Utility
>
Creating a New Database with Schema Executor
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
>
Step 3: Run the Schema Executor Utility
>
Log Messages
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Using SQL Access
>
Step 4: Optionally, Deploy the System Tables
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Example of How to Execute a Sample XML File
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Example of How to Execute a Sample XML File
>
Additional Notes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Example of How to Execute a Sample XML File
>
Additional Notes
>
SELECT Statements
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Example of How to Execute a Sample XML File
>
Additional Notes
>
Table Filters
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
D. SQL Access for COBOL Applications
>
Example of How to Execute a Sample XML File
>
Additional Notes
>
Table Filters
>
Examples of Valid TABLEFILTER Usage
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Query Plan Settings
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Graphical User Interface
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Graphical User Interface
>
Query Viewer
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Graphical User Interface
>
Plan Viewer
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Graphical User Interface
>
Plan Viewer
>
Nodes
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Graphical User Interface
>
Plan Viewer
>
Nodes
>
Node Details
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Query Plan Viewer Tasks
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Query Plan Viewer Tasks
>
SET QRYPLAN Method
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Query Plan Viewer Tasks
>
Log Query Plan Method
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Examining Query Plans and Evaluating Query Performance
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Examining Query Plans and Evaluating Query Performance
>
Creating Example Query Plans for Comparison
Developer Reference
>
Data Access Methods
>
SQL Engine Reference
>
E. Query Plan Viewer
>
Examining Query Plans and Evaluating Query Performance
>
Viewing the Example Query Plans