Catalog Objects

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks >

Catalog Objects

Previous pageReturn to chapter overviewNext page

Some types of objects are stored in SQLstream s-Server and can be created and manipulated with SQL. A SQLstream s-Server catalog is the highest level repository object; it contains metadata and state information for the catalog objects (including streams, pumps and adapters) that comprise a SQLstream s-Server repository.

Those that are contained in a schema are described in Objects within a Schema

Foreign Data Wrapper

A data wrapper that provides access from within SQLstream to an external system - for example, a remote database - via an adapter.

See also:

The topic CREATE FOREIGN DATA WRAPPER in this guide.
The topic DROP FOREIGN DATA WRAPPER in this guide.

Schema

A named catalog object containing the definitions of schema objects, such as streams, pumps, views, procedures and user defined functions.

See also:

The topic CREATE SCHEMA in this guide.
The topic DROP SCHEMA in this guide.

Server

A named catalog object that defines a particular named use of a foreign or local data wrapper, including as options any information needed to connect to the data source. SQL:2008 refers to this as a foreign server when using a foreign data wrapper.

See also:

The topic CREATE SERVER in this guide.
The topic DROP SERVER in this guide.