You can use the schemaaccess tool to perform database actions on the user's database schema.
![[Warning]](../common/images/warning.png) | Warning |
|---|---|
schemaaccess uses SQL to work directly on the database. Only use this tool when you are familiar with the database structure of CoreMedia applications. |
Usage: SchemaAccess <action> [-p|-actionParameters <parameters>]
(to use sql.properties settings)
or
SchemaAccess <driver> <jdbc:url> <user> <password> <dbtype>
<action> [-p|-actionParameters <parameters>]
Available Options:
-p|-actionParameters <parameters>: Parameters for the action
Choose <action> from:
showTables
dropTables
showViews
dropViews
showSequences
dropSequences
showIndices
showAll
dropAll
updateStatistics
clearTables
Example 3.23. Usage of schemaaccess
As is shown above, you can either add the database connection parameters to the call of schemaaccess
or only give the action as parameter and use the settings from <CoremHome>/properties/corem/sql.properties.
The actions have the following meaning:
| Action | Description |
|---|---|
| showTables |
Shows all table names of the schema owner. |
| dropTables |
Drops all the user's tables in the database schema. This does not delete blobs that are stored on the hard disk! |
| showViews |
Shows all views of the schema owner. |
| dropViews |
Drops all the user's views in the database schema. |
| showSequences |
Shows all sequences of the schema owner. |
| dropSequences |
Drops all the user's sequences in the database schema. |
| showIndices |
Shows all indices of the schema owner. |
| showAll |
This action executes showTables, showViews, showSequences and showIndices in one call. |
| dropAll |
This action executes dropTables, dropViews and dropSequences in one call. |
| updateStatistics |
Updates the statistics of the user's tables and indices in the database schema. |
| clearTables |
Deletes all data from the tables given as parameters. If no tables are given, then all tables from the schema are cleared. |
Table 3.29. Schemaaccess actions
 |  |  |
 |