DROP SERVER removes the definition of a server recorded by CREATE SERVER.
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.
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:> drop server "Northwind DB" cascade;
No rows affected (3.84 seconds)