#12114: Create View Script shows default schema name(ADMIN) with table name, though we create table in different schema

narendravatsaraj(*) reported 2014-05-12T13:29:27Z · last modified 2018-03-08T23:34:49Z

Create View Script shows default schema name(ADMIN) with table name, though we create table in different schema

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Netezza
Version	Future

Aqua Data Studio 15.0.0-dev-275
Build #: 37800
Built on: 2014-May-09 06:00:13 PM

1.Connect Netezza 7.0.3.
2.Create table in "DEFINITION_SCHEMA"

CREATE TABLE DEFINITION_SCHEMA.TEST (

C1 VARCHAR(25) NULL,

C2 VARCHAR(25) NULL

) DISTRIBUTE ON (C1)

3.Create View "ViewTest" in "DEFINITION_SCHEMA" through UI.
In source,
AS SELECT * from Test

4.View Created successfully.
5.Now Right click on that generated View ,Select Script Object to window as,Select option CREATE.

In generated script,with table name,default schema name(ADMIN) is given instead of schema(DEFINITION_SCHEMA)in which table is created.(see attached screenshot)

1 attachment

ViewScript.png

2014-05-12T13:32:19Z

163 KB

All Comments (0) Change History

Search Tips

Aqua Data Studio / nhilam

Create View Script shows default schema name(ADMIN) with table name, though we create table in different schema

1 attachment

Issue #12114

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Create View Script shows default schema name(ADMIN) with table name, though we create table in different schema

1 attachment

Issue #12114

Completion