[Database_RemoveField]
[Database_RemoveField] 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 -SQL command tag.
This tag requires a -Database and a -Table parameters that specify the database and table from which the field should be deleted. The current user must have permission to execute -SQL actions.
The -Field parameter specifies the name of the field to be deleted.
- Syntax
- Parameters
[Database_RemoveField:
-Database='Database Name',
-Table='Table Name',
-Field='Field Name']Examples
To removea field from a Lasso MySQL table:
Use the [Database_RemoveField] 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_RemoveField: -Database='Site',
-Table='MyPreferences',
-Field='CreationDate']| Tag Link | [Database_RemoveField] | Category | Database |
|---|---|---|---|
| Type | Process | Data Source | MySQL |
| Support | Preferred | Version | 5.0 |
| Output Type | None | Security | Tag |
| Implementation | LDML | Sets | Lasso 6.0, Lasso 5.0 |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
LassoSoft Inc. > Home
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft