文档介绍:: .
㍒ᕅ
ALTER TABLE ؞᭩㺘
DROP SCHEMA ࡐ䲔ᮠᦞ⁑ᔿ
TABLE ࡐ䲔㺘
VIEW ࡐ䲔㿶മ
INDEX ࡐ䲔㍒ᕅ
2ˊ ḕ䈒䈝䀰 QL
SELECT <ᮠᦞᓃ㺘.ᙗ> FROM <ᮠᦞ⁑> WHERE <ḕ䈒ᶑԦ>
3ˊ ᮠᦞᓃ㓥䈝䀰 DML
ݳ㓴䈝ਕDŽޕINSERT ᨂ
UPDATE ᴤᯠݳ㓴ᙗ٬䈝ਕDŽ
DELETE ࡐ䲔ݳ㓴䈝ਕDŽ
4ˊᮠᦞᓃ᧗ࡦ䈝ਕ DCL
GRANT ᦸᵳ䈝ਕ
REVOKE ᭦എᦸᵳ䈝ਕDŽ
COMMIT һ࣑ᨀӔ䈝ਕDŽ
ROLLBACK һ࣑എ┊䈝ਕDŽ
ㅜ3亥 ᙫ48 亥2. SQL Ⲵᮠᦞᇊѹ
SQL ⁑ᔿǃสᵜ㺘ǃ㿶മǃ㍒ᕅⲴࡋᔪ઼䬰
2. ⁑ᔿⲴࡋᔪ઼䬰
CREATE SCHEMA <⁑ᔿ> AUTHORIZATION <ѫ>
˗ 仈˖CREATE SCHEMA ST AUTHORIZATION wangֻ
DROP SCHEMA <⁑ᔿ> [ CASCADE | RESTRICT ]
CASCADE 䘎䬱ᯩᔿˈ䈕䘹ᤙᢺ SQL ⁑ᔿлⲴสᵜ㺘ǃ㿶മǃ㍒ᕅޘ䜘䬰DŽ
ݱ䇨ىRESTRICT 㓖ᶏᯩᔿˈਚᴹᖃ SCHEMA ⁑ᔿл⋑ᴹԫօлݳ㍐Ⲵᰦ
䬰䈕⁑ᔿˈࡉᤂ㔍ᢗ㹼 DROP DŽ
Ҽˈสᵜ㺘ⲴࡋᔪҾ䬰
CREATE TABLE <SQL ⁑ᔿ . สᵜ㺘>
˄
<ࡇ> <ᮠᦞ㊫ර> [ NULL | NOTNULL ] ˈ
…… ˈ
[ PRIMARY KEY( ޣ䭞ᆇ ) ] ˈ
[ FOREIGN KEY( ཆ䭞) REFERENCES <ཆ䭞㺘> ˄ѫ䭞˅]ˈ
[ CHECK( ṑ傼ᶑԦ ) ]
˅˗
DROP TABLE <สᵜ㺘> [ CASCADE | RESTRICT ];
CASCADE 䘎䬱ᯩᔿˈ䬰ᡰᴹᕅ⭘䈕㺘Ⲵ㿶മǃ㍒ᕅDŽ
RESTRICT 㓖ᶏᯩᔿˈ൘⋑ᴹ㿶മᕅ⭘䈕㺘ᰦˈਟԕࡐ䲔DŽ
ㅜ4亥 ᙫ48 亥( ㌫⁑ᔿ˖S ( SNO , SN , AGE , SEXޣ仈˖ᔪ・ᆖ⭏ֻ
CREATE TABLE S
( SNO CHAR ( 4) NOT NULL, //SNO Ѫѫ䭞ˈNOT NULL ਟⴱ⮕
SN CHAR ( 4 ) NOT NUL,
AGE SMALLINT,
SEX CHAR ( 1 ),
PRIMARY KEY( SNO )
) ˗
ᔪ・䈮〻ޣ㌫⁑ᔿ ˖C ( CNO , CN , T , CREDIT )
CREATE TABLE C
( CNO CHAR ( 4 ) NOT NUL