Catalog Objects

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.

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

Foreign Data Wrappers

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.

Schemas

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. the SQL standard 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.