CURRENT SCHEMAã?¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã?®æƒ…å ±ã?¸ã?®å?‚ç…§å??ã‚’é™?定ã?§ã??るスã‚ーマå??ã‚’è¿”ã?—ã?¾ã?™ã€‚
ã?“れらã?®é–¢æ•°ã?¯æœ€å¤§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