FreeTDS Development Group

[Igor Korot <ikorot AT earthlink.net>]

Thank you, Roger.
Now, the question is: is it specific to Sybase 11?
Is Sybase SQL Anywhere versions later than 5.5 support
this keyword?

Thank you in advance.

-----Original Message-----
>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] "),
>etc
>
>-----Original Message-----
>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
>
>Hi, ALL,
>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...
>