创建表错误-标识符无效 [英] Create table error - invalid identifier

问题描述

我正在尝试在Oracle 11g express中创建表，但是收到错误消息"ORA-00904:无效的标识符"

I'm trying to create a table in Oracle 11g express, but I receive an error "ORA-00904:invalid identifier"

CREATE TABLE Ingredients(
IngredientID    INTEGER     PRIMARY KEY     NOT NULL,
IngredientName  VARCHAR(255),
IngredientClassID   SMALLINT    NOT NULL,
MeasureAmountID     SMALLINT    NOT NULL,
CHECK (IngredientID>0),
CHECK (IngredientClassID>0),
FOREIGN KEY (IngredientClassID) REFERENCES Ingredient_Classes,
       ON UPDATE NO ACTION,
       ON DELETE CASCADE,
FOREIGN KEY (MeasureAmountID) REFERENCES Measurements,
        ON UPDATE NO ACTION,
        ON DELETE CASCADE
);

推荐答案

您是否错过了外键中的TableName(ColumnName)并添加了其他逗号. 检查正确的语法 http://docs. oracle.com/cd/E17952_01/refman-5.5-zh/create-table-foreign-keys.html

Did you miss TableName(ColumnName) in foreign key and also added additional commas. check proper syntax http://docs.oracle.com/cd/E17952_01/refman-5.5-en/create-table-foreign-keys.html

我尚未测试以下脚本.

CREATE TABLE Ingredients(
IngredientID    INTEGER     PRIMARY KEY     NOT NULL,
IngredientName  VARCHAR(255),
IngredientClassID   SMALLINT    NOT NULL,
MeasureAmountID     SMALLINT    NOT NULL,
CHECK (IngredientID>0),
CHECK (IngredientClassID>0),
FOREIGN KEY (IngredientClassID) REFERENCES Ingredient_Classes(ColumnName)
       ON UPDATE NO ACTION
       ON DELETE CASCADE,
FOREIGN KEY (MeasureAmountID) REFERENCES Measurements(ColumnName)
        ON UPDATE NO ACTION
        ON DELETE CASCADE
);

这篇关于创建表错误-标识符无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！