Invalid syntax in DROP STREAM statement

[Imran-imtiaz48]

The statement

DROP STREAM tasty_bytes.raw_pos.order_header_stream ON TABLE tasty_bytes.raw_pos.order_header;
is incorrect. In Snowflake, DROP STREAM does not support the ON TABLE clause. The correct syntax is simply:

DROP STREAM tasty_bytes.raw_pos.order_header_stream;

The ON TABLE clause is used only when creating a stream, not when dropping it.