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: "Reid, Roger L." <roger.reid AT dpw.com>
  • To: "Igor Korot" <ikorot AT earthlink.net>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] CONSTRAINTS keyword question
  • Date: Mon, 9 Apr 2007 11:06:42 -0400

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