COMPARE TABLE STRUCTURE

Compares the column structure of a table between the current connection and another connection

Arguments

<table> (mandatory) a table name, optionally schema-qualified; WITH <connection> (mandatory) a connection defined in the CDF

Examples

COMPARE TABLE STRUCTURE CUSTOMER WITH B;

Notes

Compares the column structure of a table between the current connection and another connection: COMPARE TABLE STRUCTURE <table> WITH <connection>.

<connection> must be a connection defined in the Connections Definition File (CDF); the command opens its own, separate, short lived JDBC connection to it, the current connection is never touched or replaced (see PULL ... AS H2, CommandPull, for the same design).

<table> may be schema qualified (SCHEMA.TABLE); when it is not, each side defaults independently to its own current schema, then the name is tried as typed, upper cased and lower cased on each side independently, the same case fallback DESCR uses, since two different database platforms may fold an unquoted identifier to a different case.

The report lists columns present on only one side, columns present on both sides but with a different type, size, decimal digits or nullability, and a count of columns that match exactly.

Fails with an error if <table> does not exist on either side, or if <connection> is not defined in the CDF.

Last modified in release 5.0.8.