Database version: Greenplum 4.2

Aqua Data Studio 14.0.3
Build #: 34446
Built on: 2013-Oct-16 12:54:43 PM

Windows 7: 64 bit

Step 1:  Connect to Greenplum 4.2

Step 2:  Create database.

        CREATE DATABASE "test_db"

        WITH TEMPLATE = template0

        GO

Step 3: Create two tables, in schema “gp_toolkit” and  “public” respectively.

       CREATE TABLE gp_toolkit.tab_1  (

        c1      int4 NOT NULL,

        c2      varchar(25) NULL,

        c3      varchar(25) NULL,

        PRIMARY KEY(c1) )

     DISTRIBUTED BY (c1)

     GO

       CREATE TABLE public.tab_1  (

        col1    int4 NOT NULL,

        col2    int4 NULL,

        col3    int4 NULL,

        PRIMARY KEY(col1) )

      DISTRIBUTED BY (col1)

     GO

Step 4: Select “Tools” from ADS toolbar -> Compare tools -> Schema compare -> Select above two tables for comparison -> Select checkboxes for “Include table constraints” and  “Include table constraints names” -> Click  “Compare”.(Refer image_1.jpg)

Here you will observe that, table constraints name are not included for comparison.

Moreover I observed that, databases which have system generated  table constraints names(eg. Greenplum, Informix) does not include constraint names for comparison, while databases having user defined constraint names(eg. Netezza, SQL Server 2012) include constraint name for comparison. (Refer image_2.jpg)