Appendix E - Lists of Syntax Charts

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide >

Appendix E - Lists of Syntax Charts

Previous pageReturn to chapter overviewNext page

Syntax Charts in Various Categories

You can look for a chart by object-name, action-type, or alphabetically.

Object-type List

Foreign Streams

Streams

Foreign Tables

Functions

Schemas

Views

Select & Its Clauses

Servers

Wrappers

Pumps

 


Action-type List

Create:

Schema

Server

Stream

View

Pump

Function

Foreign Server

Foreign Stream

Foreign Table

Foreign Data Wrapper

Procedure


Drop:

Schema

Server

Stream

Pump

View

Foreign Server

Foreign Data Wrapper

Foreign Stream

Foreign Table


Procedure

Function



 

Alter: Pump

Import: Foreign Schema

Discussion

Alphabetic List of All Charts

Alter Pump

Create Foreign Data Wrapper

Create Foreign Server

Create Foreign Stream

Create Foreign Table

Create Pump

Create Server

Create Stream


Create View

Drop Stream

Drop Procedure

Drop Pump

Drop View

Drop Function

Drop Schema

Drop Server



Order By (& Sort) Clauses in Streams

SELECT statement

Expression (and Order By)

(in SELECT statement)

Group By

(in SELECT statement)

Join refs (all)

(in SELECT statement)

Order By (and Expression)

(in SELECT statement)

 

Selection List,

Stream or Table Source

(in SELECT statement)

Window Specification

(in SELECT statement)

 

Sort (& Order By) Clauses in Streams

 


Windowed Aggregation &

Interval and EndPoint

 

Foreign Servers, Streams, and Data Wrappers

Foreign Server

Foreign Stream

Foreign Data Wrapper

Functions

Pumps

Create Pump

Alter Pump

Drop Pump

Schemas

Select and Its Clauses

SELECT statement

Group By

 

Window Specification

and the Query Partition clause

Selection List,

& Stream or Table Source

Order By & Expression

 

All Join refs +

 

Interval and EndPoint

Analytic Clause &

 

Windowed Aggregation


Servers

Create Server

Create Foreign Server

Drop Server

Streams

Create Stream

Create Foreign Stream

Views

Create View

Drop Table

Wrappers

Create Foreign Data Wrapper