我们可以使用tg -adminsqlhelp找到更多命令,包括删除表的命令。
You can find more commands using tg-admin SQL help, including a command to drop tables.
发出下面的命令来检查是否为表空间启用了对被删除表的恢复支持,如果没有启用,就打开它。
Issue the commands below to check whether a table space is enabled for dropped table recovery and if not, turn it on.
在使用这个命令时要特别小心,因为这会删除所有的表以及表中的数据。
Use extreme care when using this command, since it will delete all of your tables along with their data.
在命令初始化过程中,添加到表的行将对客户机可用,并且在执行命令之前可以将其删除或修改。
The rows added to the table during command initialization will be available to the client and can be deleted or modified before the execution of the command.
一个简单的DELETE命令导致DB 2从当前表移除数据,并在历史表中维护一个旧版本,包括已删除数据的结束时间。
A simple delete command causes DB2 to remove the data from the current table and maintain an old version in the history table, including the end time of the deleted data.
通过发出命令来列出被删除表的历史。
创建一个Statement来执行删除和重新创建表的命令,这允许您在数据库受损时通过此程序重置数据库。
You create a Statement to execute commands to drop and recreate the table, which allows you to reset the database from this program if it becomes corrupted.
下一个命令是SQLDROP语句,它删除bigdog 模式中的产品和供应商表。
The next commands are SQL DROP statements that delete the products and vendors tables from the bigdog schema.
下一个命令是SQLDROP语句,它删除bigdog 模式中的产品和供应商表。
The next commands are SQL DROP statements that delete the products and vendors tables from the bigdog schema.
应用推荐