This setting allows you to define whether a delete all or drop will be executed when the delete table statement is used with a SQL table.
SQLDropTableOnDelete=option
• option - A boolean that indicates whether a delete all or drop will be executed when the delete table statement is used. It can be set to one of the following:
![[spacer]](1p.gif){kind=small}
|
Value |
Description |
|---|---|
|
TRUE |
Use the drop functionality, which removes the data and the table structure from the database. |
|
FALSE |
Use the delete all functionality, which removes all of the data in the table, but leaves the empty table intact in the database. |
If this setting is included in the defaults file of a client computer, it determines the functionality of the delete table statements issued from that computer. However, the Table_SetDeleteOptions() function overrides this setting.
If this setting or Table_SetDeleteOptions() isn’t used, the drop functionality of the delete table statement will be used.
Be sure to take Table_SetCreateMode() into consideration when deciding which delete functionality to use. If that function is set to false, dropped tables won't be created automatically then next time a user tries to access them. To have Dexterity automatically create a dropped table the next time a user tries to access that table, use Table_SetCreateMode() to set the autocreate functionality to true before the user attempts to access the table.