-- 符合约束的标识符作为名称,定义时使用双引号
CREATE TABLE "CREATE01" (c1 INT); -- 按全大写定义名称
Succeed.
INSERT INTO Create01 VALUES(1); -- 不加双引号引用时,不区分大小写
1 row affected.
INSERT INTO "Create01" VALUES(1); -- 加双引号引用时,严格区分大小写
[1:12]YAS-02012 table or view does not exist
DROP TABLE Create01;
Succeed.
CREATE TABLE "CREATe01" (c1 INT); -- 按非全大写定义名称时,引用名称时必须使用双引号,且严格区分大小写
Succeed.
INSERT INTO CREATE01 VALUES(1);
[1:12]YAS-02012 table or view does not exist
INSERT INTO "CREATE01" VALUES(1);
[1:12]YAS-02012 table or view does not exist
INSERT INTO "CREATe01" VALUES(1);
1 row affected.
-- 违反约束的标识符作为名称,定义和引用都必须使用双引号
CREATE TABLE "CREATE" (c1 INT); -- 按全大写定义名称时,引用时严格区分大小写
Succeed.
INSERT INTO CREATE VALUES(1);
[1:12]YAS-04202 missing or invalid table name
INSERT INTO "CREATE" VALUES(1);
1 row affected.
INSERT INTO "Create" VALUES(1);
[1:12]YAS-02012 table or view does not exist
DROP TABLE "CREATE";
Succeed.
CREATE TABLE "Create" (c1 INT); -- 按非全大写定义名称时,引用时严格区分大小写
Succeed.
INSERT INTO Create VALUES(1);
[1:12]YAS-04202 missing or invalid table name
INSERT INTO "CREATE" VALUES(1);
[1:12]YAS-02012 table or view does not exist
INSERT INTO "Create" VALUES(1);
1 row affected.
评论