Product: Aqua Data Studio
Version: 17.0.0-dev-74
Build #: 44661
Build Date: 2015-Jul-09 05:29:58 PM
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_40-b26
Memory: Max=954,728,448; Total=348,127,232; Free=15,982,968; CPUs=8
Connect to Teradata Aster Database 6.
Steps:
1.Execute following script on Query Analyzer to create new table which is having primary key,unique key & check constraint.
CREATE FACT TABLE [public].[na_all] (
[iplow] ip4 NOT NULL,
[iphigh] ip4 NULL,
[ctry] varchar(25) NULL,
PRIMARY KEY([iplow])
)
DISTRIBUTE BY HASH ([iplow])
STORAGE COLUMN
COMPRESS LOW
GO
ALTER TABLE [public].[na_all]
ADD CONSTRAINT [unique_key3]
UNIQUE ([iplow])
GO
ALTER TABLE [public].[na_all]
ADD CONSTRAINT [checkkey1]
CHECK ((ctry::text <> 'a'::text))
GO
2.After creating table go to public schema.
3.Add Detail view pane in ADS.
4.Click on Constraints object folder in schema node.
5.In Detail pane, unique key is not displayed.
