[freetds] CONSTRAINTS keyword question
ikorot at earthlink.net
Mon Apr 9 21:20:31 EDT 2007
Thank you, Roger.
Now, the question is: is it specific to Sybase 11?
Is Sybase SQL Anywhere versions later than 5.5 support
Thank you in advance.
>From: "Reid, Roger L." <roger.reid at dpw.com>
>Sent: Apr 9, 2007 8:06 AM
>To: Igor Korot <ikorot at earthlink.net>, FreeTDS Development Group <freetds at lists.ibiblio.org>
>Subject: RE: [freetds] CONSTRAINTS keyword question
>CONSTRAINT (not CONTSTRAINTS) does exist in Sybase 11 - example from Rankin's Sybase SQL Server 11 Unleashed:
>create table prices
> (item_code char(4) not null
> contstraint item-code-constraint
> check (item_code like "[0-9] [0-9] [0-9] [0-9] "),
>From: Igor Korot [mailto:ikorot at earthlink.net]
>Sent: Saturday, April 07, 2007 6:37 PM
>To: FreeTDS Development Group; freetds at lists.ibiblio.org
>Subject: [freetds] CONSTRAINTS keyword question
>This might be the stupid question, but I can't verify it for sure, so....
>Is there a 'CONSTRAINTS' keyword in the CREATE TABLE statement in the Sybase
>SQL Anywhere or Sybase 10/11?
>I am working with another open source library trying to fix some bugs there,
>the code for the ODBC DB access for both Sybase drivers for the CREATE TABLE
>statement is wrong IMHO, since it is include the 'CONSTRAINT' keyword...
More information about the FreeTDS