Show Steps
Summary
The SHOW STEPS command returns a result set listing metadata for all step objects defined in the Connect environment.
Syntax
show steps; |
Parameters
None.
Details
Use the SELECT command to query the SHOW STEPS result set as a table.
|
Column Name
|
Data Type
|
Description
|
|---|---|---|
| id | string | Unique identifier for each step object |
| name | string | Step name given by developer |
| description | string | Notes a developer added to the step object |
| command | string | The command expressions associated with the step. |
| labels | string | A descriptive tag that a developer added to describe the purpose of the step. Refer to ALTER STEP “add label”. |
| created_by | string | Connect developer who created the step |
| created_instant | instant | Instant when a developer created the step |
| modified_by | string | Connect developer who last modified the step |
| modified_instant | instant | Instant when a developer last modified a step |
Examples
show steps;
select name, created_instant, modified_instant
from (show steps)
where modified_instant is not null
order by created_instant;
Related Commands