close

Filter

loading table of contents...

Content Server Manual / Version 2207

Table Of Contents

3.13.2.16 Schemaaccess

You can use the schemaaccess tool to perform database actions on the user's database schema.

Warning

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.38.  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 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.36.  Schemaaccess actions


Search Results

Table Of Contents
warning

Your Internet Explorer is no longer supported.

Please use Mozilla Firefox, Google Chrome, or Microsoft Edge.