#11250: Create or Replace view script is generated in view source body on Netezza database.

nileshhmali reported 2014-01-03T10:01:29Z · last modified 2018-03-08T23:42:00Z

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Netezza
Version	Future - PM

ADS Version : Aqua Data Studio 15.0.0-dev-62

Database: Netezza 7.0

Connect to Netezza database

Create table

CREATE TABLE "test_tb" (

"col1" DATE NULL,

"col2" VARCHAR(25) NULL,

"col3" VARCHAR(25) NULL

) DISTRIBUTE ON ("col1")

COMMENT ON TABLE "test_tb" IS 'comment on table'

COMMENT ON COLUMN "test_tb"."col3" IS 'Comment on column'

Create view

CREATE VIEW "test_view"

SELECT "test_tb"."col2" FROM "test_tb"

Go to view node->Right click on "test_view" view->Select view properties-> Open view properties window.

Now you will observe that,Create or Replace view script is generated in view source body.

All Comments (0) Change History