vendredi 2 janvier 2015

SQL error: near ".": syntax error

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