[ASE 12.5.3a] SQL Reference

[taproot]

Hi all,

I'm new at the forum and I don't speak french (although I understand it due to 3 years of French classes in school). Also , I'm currently working with Sybase ASE 12.5.3a, first time ever with a Sybase database.

My problem is simple to explain! I created a Physical Model using Enterprise Architect, and generated the correspondent SQL, this model was full of column comments that will help the development team and these comments are also in the SQL generated in the following form:

COMMENT ON COLUMN "TRC_Actions"."actionId" IS
'Action Identifier'
go

But, when I try to generate the database in Sybase ASE I get lots of syntax errors. I researched it for a bit of time and learn that the SQL that was generated was for Sybase ASA and not ASE.

Is there any syntax for inserting column comments in Sybase ASE 12.5.3a?

Hope you can help me

TIA,
Gonçalo

[mpeppler]

Il existe des forums en anglais - p.ex. www.dbforums.com, ou encore forums.sybase.com.

Mais pour répondre à la question: ASE n'a pas de concept de commentaire pour les colonnes des tables, donc cette syntaxe n'est pas valide.

Michael