Issues with Creating Tables

Virtuoso Universal Server SQL Data Management
,
1

Hello guys!
I’m having trouble creating a relational database on virtuoso. I can’t use “CONSTRAINT” or INDEX, below follows the code I have developed … Constraint works without actions …
Someone can help me?

CREATE TABLE “BASEDADOSTESEFINAL”. “SAMPLE_SCHEMA”. “Terms” (
“TermID” INTEGER NOT NULL IDENTITY,
“TermName” VARCHAR (50) NOT NULL,
“Research_Output_ResearchOutputID” INTEGER NOT NULL,
PRIMARY KEY (“TermID”),
INDEX_ “fk_Terms_Research_Output1_idx” (“Research_Output_ResearchOutputID” ASC) VISIBLE,
CONSTRAINT “fk_Terms_Research_Output1”
FOREIGN KEY (“Research_Output_ResearchOutputID”)
REFERENCES “BASEDADOSTESEFINAL”. “SAMPLE_SCHEMA”. “Research_output” (“ResearchOutputID”)
ON DELETE NO ACTION
ON UPDATE NO ACTION)

2

What exactly is not working, please provide a complete test case for the issue being run that can be executed from the Virtuoso isql command line tool to create locally ? Here you can find documentation on what is supported the Virtuoso CREATE TABLE command.

What is INDEX_ “fk_Terms_Research_Output1_idx” (“Research_Output_ResearchOutputID” ASC) VISIBLE as that does not look as if it is support, thus where was it devised from and what is it expected to do ?

What is the definition of the BASEDADOSTESEFINAL”. “SAMPLE_SCHEMA”. “Research_output” table ?