Skip to Content.
Sympa Menu

freetds - Re: [freetds] CONSTRAINTS keyword question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Igor Korot <ikorot AT earthlink.net>
  • To: "Reid,Roger L." <roger.reid AT dpw.com>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] CONSTRAINTS keyword question
  • Date: Mon, 9 Apr 2007 18:20:31 -0700 (GMT-07:00)

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...
>





Archive powered by MHonArc 2.6.24.

Top of Page