1. Create Schema

Open new Query page and input "CREATE SCHEMA '$schema name$'. After then click execution(⚡).
Now you can see new schema, after refreshing the schema list.

Open new query page icon

 

2. Create Table

If you write down a code for creating a table right below the code creating a schema. It wouldn't work.
Becasue the system would read the code for creating the schema again and then it occur error. 
To avoid the error, you could highlight the code which the execution should read or open new query page.

*To avoid running the same code again by accident, you can just highlight and press "Ctrl + / (slash)"

반응형

+ Recent posts