Remove Table Column
remove_table_columnDelete a ServiceNow table column and verify its DELETE capture in the given update set. Requires confirmation; blocks columns with data or dependent scripts/policies unless acknowledged.
Instructions
Remove a column from a table (the platform's Delete on its dictionary record), with every DELETE capture verified in the named update set. It deletes the column's data here and wherever the set is committed: only when the user asked. Refused while rows hold values, or while client scripts or UI policy actions name it, unless those are acknowledged.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| scope | No | The record's application: its scope name (e.g. "x_acme_app"), or "global". Give this or scope_id. | |
| table | Yes | The table. | |
| column | Yes | The column name, prefix included (u_ in Global). | |
| confirm | Yes | Type <table>.<column> exactly, to confirm the removal. | |
| instance | No | The ServiceNow instance auth alias to connect to. This is the alias configured via `snc configure` (e.g., "myinstance", "prod", "test"). The user will typically refer to this by name when saying things like "on my myinstance instance". If not provided, falls back to the SN_AUTH_ALIAS environment variable. | |
| scope_id | No | The record's application by sys_scope sys_id, instead of scope. | |
| update_set | Yes | sys_id of an In progress update set of that application (create_update_set). The capture is verified there; for adding a column and for layout saves it must also be the working set (set_current_update_set). | |
| acknowledge_data_loss | No | Rows hold values in the column and the user agreed they are deleted with it. | |
| acknowledge_upgrade_skip | No | Only for an installed Store application, and only after the user has reviewed the change: upgrades of that application then skip this file until the customization is reviewed. | |
| acknowledge_dependent_deletes | No | The user agreed the platform also deletes the client scripts and UI policy actions that name the column. |