[Squirrel-sql-users] Problem with CREATE TABLE auto-generated script in Sybase

[Alexandre P. <Ale...@ei...>]

Hi,
I noticed that auto-generated "CREATE TABLE" script uses only "NOT NULL" column attributes, so all the columns in the resulted table are "NOT NULL".
ASE documentation states: "If you do not specify null or not null, Adaptive Server uses not null by default."  There is a way to change ASE default, but it requires role_sa role, which I don't have.
Is there a setting somewhere that can change the (SQL default) behavior of SQuirreL SQL to ASE-specific behavior?
-- 
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Einstein-Montefiore Institute for Clinical and Translational Research (ICTR)
Albert Einstein College of Medicine
1300 Morris Park Ave, Mazer Bldg., Rm 534
Bronx, NY 10461
(718) 430-2440 (Mo, We, Fr)  (718) 920-4885 (Tu & Th)