Product: Aqua Data Studio
Version: 15.0.0-dev-94
Database Version : Redshift
Connect Redshift:-
Create table
CREATE TABLE "information_schema"."test_t1_table"(
"col1" varchar(25)NULL,
"col2" varchar(25)NULL,
"col3" varchar(25)NULL
)
GO
Go to database tree node and expand it-> Select table folder and expand it-> Select table "test_t1_table"->
Right click on it-> Tool option-> Select Export Data option->
Export window is displayed-> Select 'information_schema' under schema drop down list-> select tables from object type.
Now you will observe that,Table list are displayed Under schema 'information_schema'.
Again, Go to database tree node and expand it-> Select table and expand it-> Select table "test_t1_table"->
Right click on it-> Tool option-> Select schema script generator option-> Script generator window is opened-> Select 'information_schema' under schema drop down list-> select tables from object type.
Now you will observe that,table list are not displayed Under schema 'information_schema'.
Information_schema is a system schema. I changed the extraction to treat it as such. It has moved out of the table tree node and into the system table tree node.