CURRENT SCHEMA関数

CURRENT SCHEMAã?¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã?®æƒ…å ±ã?¸ã?®å?‚ç…§å??ã‚’é™?定ã?§ã??るスキーマå??ã‚’è¿”ã?—ã?¾ã?™ã€‚

注: CURRENT SCHEMAã?¨CURRENT SQLIDã?¯åˆ¥å??ã?§ã?™ã€‚

�れら�関数�最大128文字�文字列を返���。

æ§‹æ–‡

CURRENT SCHEMA

-- ����

CURRENT SQLID
-- nameã?¨ã?„ã?†åˆ—ã?®æ—¢å®šå€¤ã‚’ç?¾åœ¨ã?®ã‚¹ã‚­ãƒ¼ãƒžå??ã?«ã?™ã‚‹ã€‚
CREATE TABLE mytable (id int, name VARCHAR(128) DEFAULT CURRENT SQLID)
-- 表ã?«ç?¾åœ¨ã?®ã‚¹ã‚­ãƒ¼ãƒžå??ã?¨ã?ªã?£ã?¦ã?„る既定値を挿入ã?™ã‚‹ã€‚
INSERT INTO mytable(id) VALUES (1)
-- ç?¾åœ¨ã?®ã‚¹ã‚­ãƒ¼ãƒžã?¨å?Œã?˜å??å‰?ã?®è¡¨ã‚’è¿”ã?™ã€‚
SELECT name FROM mytable WHERE name = CURRENT SCHEMA