DROP FOREIGN STREAM removes the definition of a foreign stream previously defined by CREATE FOREIGN STREAM.
The foreign stream will not be dropped if any other objects (views or pumps) depend upon it - unless the CASCADE option specified. The default is RESTRICT.