[freetds] CONSTRAINTS keyword question
Igor Korot
ikorot at earthlink.net
Tue Apr 10 02:01:30 EDT 2007
James,
Thank you for the reply. It clarifies many things...
I took a closer look at the help provided with my copy of
SQL Anywhere 5.5. It supports 2 SQL: Watcom-SQL and Transact-SQL.
Watcom-SQL support is set by default.
However, if you want to write a Sybase Server portable DB, you should
use a Transact-SQL dialect.
Problem is, the Watcom-SQL does not support named constraints, and Transact-SQL
does, and it looks like there is no way to find out, whether the DB
is set to use the one or another. However, it is possible, that if
I set the DB to use Transact-SQL dialect, than the code might as well
return: "I'm using the Sybase Server".
I'm just guessing here, but maybe I'm right?
Also, is Sybase support the Watcom-SQL standard in the latest SQL Anywhere
releases?
Thank you.
-----Original Message-----
>From: "James K. Lowden" <jklowden at freetds.org>
>Sent: Apr 9, 2007 6:16 PM
>To: Igor Korot <ikorot at earthlink.net>, FreeTDS Development Group <freetds at lists.ibiblio.org>
>Subject: Re: [freetds] CONSTRAINTS keyword question
>
>Igor Korot wrote:
>> Is there a 'CONSTRAINTS' keyword in the CREATE TABLE statement in the
>> Sybase SQL Anywhere or Sybase 10/11?
>
>Google is your friend:
>
>http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@ebt-link;pt=20741?target=%25N%15_20838_START_RESTART_N%25
>
>--jkl
More information about the FreeTDS
mailing list