Aqua Data Studio 15.0.0-dev-91
Database:Teradata Aster 5.0
1.In ADS,connect to Teradata Aster database,expand it
Go to Databases object folder,expand it
Select beehive database and expand it
Go to "public" schema and expand it
Open Query Analyzer using shortcut key Ctrl+Q and execute the following script
CREATE DIMENSION TABLE "public"."Date_Time_DT" (
"colume1" date NOT NULL,
"column2" time without time zone NULL,
"column3" time with time zone NULL,
"column4" timestamp without time zone NULL,
"column5" timestamp with time zone NULL,
PRIMARY KEY("colume1")
)
DISTRIBUTE BY REPLICATION
STORAGE ROW
COMPRESS MEDIUM
GO
ALTER TABLE "public"."Date_Time_DT"
ADD CONSTRAINT "unique_key"
UNIQUE ("colume1")
GO
INSERT INTO [Date_Time_DT]([colume1], [column2], [column3], [column4], [column5])
VALUES('2014-01-31', '15:57:07', '02:27:07', '2014-01-31 15:57:07.0', '2014-02-01 02:27:07.0')
GO
INSERT INTO [Date_Time_DT]([colume1], [column2], [column3], [column4], [column5])
VALUES('2014-01-30', '15:57:07', '02:27:07', '2014-01-31 15:57:07.0', '2014-02-01 02:27:07.0')
GO
Table get created with unique key,primary key in public schema and records get inserted in table
2.Go to Databases object folder
Right click on Databases object folder
Go to Tools option and select Schema Script Generator option
Schema Script Generator window get opened
In Schema Script Generator window select database as beehive and schema as public from drop down list
check Tables object under Object Types pane
click Next button
3.In Options pane for Save as: option select Preview Tab option from drop down list
Check Generate the CREATE,Include INSERT statements for Table data,Include blank line between statements options
Click Next button
4.In Preview Tab,Create Table,Insert and Alter Table script get generated
but blank line does not get included between Insert and Alter Table script
even if I have check Include blank line between statements options
line should get included between statements
