CREATE SCHEMA æ–‡

スキーマã?«ã‚ˆã‚Šæƒ…報を論ç?†çš„ã?«ä¸€ã?¤ã?®é›†å?ˆã?«åˆ†é¡žã?™ã‚‹ã?“ã?¨ã€?ã?Šã‚ˆã?³ã€?一æ„?ã?ªå??å‰?空間をæ??ä¾›ã?™ã‚‹äº‹ã?Œã?§ã??ã?¾ã?™ã€‚

æ§‹æ–‡

CREATE SCHEMA { [ スキーマå?? AUTHORIZATION ユーザå?? ] | [ スキーマå?? ] | 
[ AUTHORIZATION ユーザå?? ] }

CREATE SCHEMA æ–‡ã?«ã‚ˆã‚Šã‚¹ã‚­ãƒ¼ãƒžã‚’作æˆ?ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚スキーマå??ã?¯128文字を超ã?ˆã?¦ã?¯ã?ªã‚Šã?¾ã?›ã‚“。スキーマå??ã?¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã?®å†…ã?§ä¸€æ„?ã?§ç„¡ã?‘れã?°ã?ªã‚Šã?¾ã?›ã‚“。

CREATE SCHEMAæ–‡ã?¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã?ªã?„ã?—システムã?«ã?Šã?„ã?¦ã€?derby.database.sqlAuthorizationã?Œtrueã?¨ã?ªã?£ã?¦ã?„ã‚‹å ´å?ˆã€?アクセス制御ã?®å¯¾è±¡ã?¨ã?ªã‚Šã?¾ã?™ã€‚データベース所有者ã? ã?‘ã?Œç?¾åœ¨ã?®ãƒ¦ãƒ¼ã‚¶å??ã?¨ã?¯ç•°ã?ªã‚‹å??å‰?ã?®ã‚¹ã‚­ãƒ¼ãƒžã‚’作æˆ?ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ã?¾ã?Ÿãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ‰€æœ‰è€…ã? ã?‘ã?Œç?¾åœ¨ã?®ãƒ¦ãƒ¼ã‚¶å??ã?¨ã?¯ç•°ã?ªã‚‹
AUTHORIZATION user-name
を指定ã?§ã??ã?¾ã?™ã€‚ derby.database.sqlAuthorization属性ã?«ã?¤ã?„ã?¦ã?®ã‚ˆã‚Šè©³ç´°ã?ªæƒ…å ±ã?¯ã€?Derbyã?®ãƒ?ューニングをå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。

CREATE SCHEMA�例

飛行機ã?«é–¢é€£ã?—ã?Ÿè¡¨ã‚’ã?Šã??スキーマを作æˆ?ã?—ã?¦ã€?anitaã?¨ã?„ã?†èª?証識別å­?ã?«ã‚¹ã‚­ãƒ¼ãƒžã?®å…¨ã?¦ã?®æƒ…報をæ“?作ã?™ã‚‹æ¨©é™?を与ã?ˆã‚‹ã?«ã?¯æ¬¡ã?®ã‚ˆã?†ã?«ã?—ã?¾ã?™ã€‚
CREATE SCHEMA FLIGHTS AUTHORIZATION anita 
従業員ã?«é–¢é€£ã?—ã?Ÿè¡¨ã‚’ã?Šã??スキーマを作æˆ?ã?™ã‚‹ã?«ã?¯æ¬¡ã?®ã‚ˆã?†ã?«ã?—ã?¾ã?™ã€‚
CREATE SCHEMA EMP 
takumiã?¨ã?„ã?†ã‚¹ã‚­ãƒ¼ãƒžå??ã?Œã??ã?®ã?¾ã?¾èª?証識別å­?ã?§ã?‚るスキーマを作æˆ?ã?™ã‚‹ã?«ã?¯æ¬¡ã?®ã‚ˆã?†ã?«ã?—ã?¾ã?™ã€‚
CREATE SCHEMA AUTHORIZATION takumi 
EMP�FLIGHTS��スキーマ�availability���表を作��る��次�よ�����。
CREATE TABLE FLIGHTS.AVAILABILITY
	(FLIGHT_ID CHAR(6) NOT NULL, SEGMENT_NUMBER INT NOT NULL,
	FLIGHT_DATE DATE NOT NULL, ECONOMY_SEATS_TAKEN INT,
	BUSINESS_SEATS_TAKEN INT, FIRSTCLASS_SEATS_TAKEN INT, 
	CONSTRAINT FLT_AVAIL_PK
	PRIMARY KEY (FLIGHT_ID, SEGMENT_NUMBER, FLIGHT_DATE)) 
CREATE TABLE EMP.AVAILABILITY
	(HOTEL_ID INT NOT NULL, BOOKING_DATE DATE NOT NULL, ROOMS_TAKEN INT,
	CONSTRAINT HOTELAVAIL_PK PRIMARY KEY (HOTEL_ID, BOOKING_DATE))
Related reference
CREATE FUNCTION æ–‡
CREATE INDEX æ–‡
CREATE PROCEDURE æ–‡
CREATE SYNONYM æ–‡
CREATE TABLE æ–‡
CREATE TRIGGER æ–‡
CREATE VIEW æ–‡