Lasso Soft Inc. > Home

[Database_RemoveTable]

[Database_RemoveTable] removes a table from an existing MySQL database. Any data in the specified table 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 parameter that specifies the database from which the tables should be deleted. The current user must have permission to execute -SQL actions.

The -Table parameter specifies the name of the table to be deleted.

  • Syntax
  • Parameters
[Database_RemoveTable:
  -Database='Database Name',
  -Table='Table Name']
Required Parameters
-Database The name of the database from which the table should be removed.
-Table The name of the table to be removed.
Examples

To removeLasso MySQL table:

Use the [Database_RemoveTable] tag. The following code removes a table named MyPreferences from the Site database.

All of the data in this table as wll as all the field definitions will be removed permanently. There is no way to undo this action.

[Database_RemoveTable: -Database='Site', -Table='MyPreferences']
Tag Link [Database_RemoveTable] Category Database
Type Process Data Source MySQL
Support Preferred Version 5.0
Output Type None Security Tag
Implementation Sets 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 | PrivacyLegal terms and Shipping | Contact LassoSoft