Subject | Creating Tables Problem |
---|---|
Author | German Terrazas |
Post date | 2003-03-05T14:47:01Z |
hello,
I need to create a table at a stored procedure, but it fails. The sql code
is the following:
BEGIN
CREATE TABLE 'TTEST' (
ID INTEGER NOT NULL PRIMARY KEY,
FIELDNAME VARCHAR(150) NOT NULL,
FIELDVALUE INTEGER,
DOCUMENT_ID INTEGER);
END
Error Message --> Token unknown CREATE
How can I perform this ?
thnx,
german
I need to create a table at a stored procedure, but it fails. The sql code
is the following:
BEGIN
CREATE TABLE 'TTEST' (
ID INTEGER NOT NULL PRIMARY KEY,
FIELDNAME VARCHAR(150) NOT NULL,
FIELDVALUE INTEGER,
DOCUMENT_ID INTEGER);
END
Error Message --> Token unknown CREATE
How can I perform this ?
thnx,
german