[freetds] CONSTRAINTS keyword question
Reid, Roger L.
roger.reid at dpw.com
Mon Apr 9 11:06:42 EDT 2007
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...
More information about the FreeTDS
mailing list