DROP TABLE Summary The DROP TABLE command drops the specified table from the environment. Dropping a table deletes all existing data in the table (the data is not recoverable). Syntax […]

Drop Variable Summary The DROP VARIABLE command drops the specified variable. Syntax drop variable [if exists] <name>; Parameters Parameter Description [if exists] Suppresses error messages ...

Drop Step Summary The DROP STEP command removes the specified step domain object from the Connect instance. Syntax drop step [if exists] <step_name>; Parameters Parameter Description [if exist...

Drop Schedule Summary The DROP SCHEDULE command removes the specified schedule from Connect. Syntax drop schedule [if exists] <schedule_name>; Parameters Parameter Description [if exists] (Opti...

Drop Pipeline Summary The DROP PIPELINE command removes the specified pipeline domain object from the Connect instance. Syntax drop pipeline [if exists] <pipeline_name>; Parameters Parameter Des...

Drop Email Summary The DROP EMAIL command drops the specified email object. Syntax drop email [if exists] <email_name>; Parameters Parameter Description <email_name> The name of the email ...

Create and Use Global Variables Connect’s xSQL language allows you to create global variables. These variables persist across sessions and users, and can store: Literal values Expressions that resol...

Variables are persistent across sessions and users. In some cases, best practices dictate that we remove a variable. The DROP and UNSET commands both do this, and function the same […]