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.

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)"
반응형
'#독학로그_IT,개발,데이터 > 관계형 데이터 모델링' 카테고리의 다른 글
관계형 데이터 베이스 공부(Cardinality, Optionality, ERD) (0) | 2022.01.15 |
---|