I am new to database. I am trying to execute some commands of sqlite3 are following.
ATTACH DATABASE "SsmOutPort" AS SsmOutPort;
BEGIN;
DROP TABLE SsmOutPort.MappingTable;
CREATE TABLE SsmOutPort.MappingTable(id INT,tableName varchar(50),persistency varchar(20),maxRecords INT,PRIMARY KEY(id));
DROP TABLE SsmOutPort.MappingFields;
CREATE TABLE SsmOutPort.MappingFields(tableId INT,fieldId INT,fieldName varchar(50),fieldType varchar(10),defaultvalue INT,PRIMARY KEY(tableId,fieldId));
CREATE UNIQUE INDEX X ON SsmOutPort.MappingTable(id);
Create unique Index is Giving Error
SQL error: near ".": syntax error
or if i will remove SsmOutPort it give following error
SQL error: no such table: main.MappingTable
Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire