| Tag Link | [Database_RemoveColumn] | Category | Database |
|---|---|---|---|
| Type | Process | Source Available | Yes |
| Support | Synonym | Version | 5.0 |
| Change | Unchanged | Data Source | Lasso MySQL |
| Output Type | None | Security | Tag |
| Implementation | LDML | Sets | Lasso 8.5, Lasso 8.0, Lasso 7.0, Lasso 6.0, Lasso 5.0 |
[Database_RemoveColumn] removes a field from an existing MySQL database table. Any data in the specified field will be permanently destroyed.
This tag is certified to work with Lasso MySQL and MySQL data sources. It may also work with third party data sources that support the
This tag requires a
The
[Database_RemoveColumn:
| Required Parameters | |
|---|---|
| -Database | The name of the database from which the field should be removed. |
| -Table | The name of the table from which the field should be removed. |
| -Field | The name of the field to be removed. |
To remove a field from a Lasso MySQL Table:
Use the [Database_RemoveColumn] tag. The following code removes a field named CreationDate from the MyPreferences table in the Site database.
All of the data in this field as wll as all the field definition will be removed permanently. There is no way to undo this action.
[Database_RemoveColumn: