Description

Dump database schema to file.

XML namespace

<pct:schema_dump />

Parameters

Attribute Description  
destFile ‡ Destination file to dump the schema  
tables Dumps only the selected tables. Comma-separated list  

† Only one of those attributes is mandatory ‡ Mandatory attribute

PCTDumpSchema inherits attributes from PCT and PCTRun. However, PCTDumpSchema must have one and only one DBConnection.

Parameters as nested elements

Table

Dumps a specific table. Merged with the tables attribute.

Examples

<PCTDumpSchema destFile="schema.df" dlcHome="${DLC}">
  <DBConnection dbName="test" singleUser="true" />
</PCTDumpSchema>
Connects in single-user mode to test.db and dumps schema to schema.df

Can be followed by: 

<copy file="schema.df" tofile="schema.df">
  <filterchain>
    <tailfilter lines="-1" skip="6" />
  </filterchain>
</copy>
To remove the useless and cumbersome trailer from the dump file.