Would someone kindly have some suggestions for this
user
http://www.nabble.com/%27Unsupported-upgrade-from-10.1-to-10.2-beta%27---Cannot-Connect-to-Demo-Databases-tf4256082.html#a12179867
Thank you
John
That's fine if there are no triggers or other objects associated with the
original table. Is there a system procedure or the like for finding such
objects?
Absolutely!
http://db.apache.org/derby/docs/dev/ref/rrefsistabs38369.html
thanks,
bryan
Bryan Pendleton wrote:
>
>> SQL state 42601: ALTER TABLE statement cannot add an IDENTITY column to a
>> table.
>>
>> Is there any way to work around this?
>
> Perhaps:
>
> 1) create a new table with all the columns of the existing table,
> plus the new identity column.
> 2) INSERT INTO
adedayo damilola wrote (2007-08-16 14:05:27):
> After reading the Derby document(s) I discovered that the UNIQUE
> constraint in Derby does not allow NULL values to be inserted into a
> cloumn with the constraint applied. So I was wondering if there was
> another way to achieve since t
After reading the Derby document(s) I discovered that the UNIQUE constraint in
Derby does not allow NULL values to be inserted into a cloumn with the
constraint applied. So I was wondering if there was another way to achieve
since the UNIQUE constraint was designed to do this
-
Dag H. Wanvik wrote:
Mark Thornton <[EMAIL PROTECTED]> writes:
The syntax in the documentation
(http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html) implies
that you can add more than one constraint in a single alter table
Does it? If a syntactic element can be repeated, there
Mark Thornton <[EMAIL PROTECTED]> writes:
> The syntax in the documentation
> (http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html) implies
> that you can add more than one constraint in a single alter table
Does it? If a syntactic element can be repeated, there will be an
asterisk trailin
The syntax in the documentation
(http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html) implies
that you can add more than one constraint in a single alter table
statement, as in this example
ALTER TABLE APP.ACTIVEVEHICLES
ADD CONSTRAINT FK__ACTIVEVEH__VEHIC__7A3223E8 FOREIGN KEY (VEHICLE