Thanks for the answer. I have looked into that list and it seems that
altering a table for forging constrains is not working as well, since I
get a similar error on ALTER commands with constraints. How can I
change constraints on already existing tables? I 'am trying to run this
command:
-- Add foreign key constraints to table assetdownload.
alter table assetdownload
add constraint assets_assetdownload_FK1 foreign key (assetId)
references assets (assetId)
ON UPDATE CASCADE ON DELETE CASCADE;
Cheers?
-----Original Message-----
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 24, 2007 4:29 PM
To: SQLite
Subject: [sqlite] Re: Is this SQL command supported?
Ahmed Sulaiman <[EMAIL PROTECTED]>
wrote:
> I wonder if there any SQL commands that are not supported by SQLite.
Yes. See http://sqlite.org/lang.html for a complete documentation of the
SQL dialect supported by SQLite.
> {"SQLite error\r\nnear \"DOMAIN\": syntax error"}
>
> CREATE DOMAIN D_BOOLEAN AS SMALLINT DEFAULT 0
> CHECK (VALUE BETWEEN 0 AND 1);
SQLite doesn't support CREATE DOMAIN statement.
Igor Tandetnik
------------------------------------------------------------------------
-----
To unsubscribe, send email to [EMAIL PROTECTED]
------------------------------------------------------------------------
-----
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
