DROP SERVER

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > DROP statements >

DROP SERVER

Previous pageReturn to chapter overviewNext page

DROP SERVER removes the definition of a server recorded by CREATE SERVER.

Syntax

dropserver

Notes

If there are any objects defined that reference the server (for example, any foreign streams or tables), then they must be removed prior to dropping the server, or the CASCADE option must be specified. RESTRICT is the default.

Examples

0: jdbc:sqlstream:> drop server "Southwind Oracle";

No rows affected (0.502 seconds)

0: jdbc:sqlstream:> drop server "Northwind DB";

Error: Dropping data server "SYS_BOOT"."Northwind DB" requires CASCADE because

               other objects still reference it (state=,code=0)

0: jdbc:sqlstream:>

0: jdbc:sqlstream:> drop server "Northwind DB" cascade;

No rows affected (3.84 seconds)