<div>
Sybase Central (shipped with ASA) can do this for you. Right click on the table and you should see something about &quot;Generate DDL&quot;. 
</div>


Sybase Central (shipped with ASA) can do this for you. Right click on the table and you should see something about "Generate DDL".

<div>
Am sorry Joe, I could not find &quot;Generate DDL&quot; at all :-(((((<br />
any other way...its urgent
</div>


Am sorry Joe, I could not find "Generate DDL" at all :-(((((
any other way...its urgent

<div>
Sorry, I don't have a copy of ASA to check exactly where it's Sybase Central puts its commands. (Sybase has an unfortunate habit of not standardising the various Sybase Central versions for their different products...) If you have Sybase Central for ASA, it's there somewhere... 
</div>


Sorry, I don't have a copy of ASA to check exactly where it's Sybase Central puts its commands. (Sybase has an unfortunate habit of not standardising the various Sybase Central versions for their different products...) If you have Sybase Central for ASA, it's there somewhere...

<div>
Sorry I couldnot find out any...<br />
I was planning to use the foll command as of now...<br />
<br />
select cname,coltype,length,nulls<wbr /> from sys.syscolumns where tname='#rps_500_temp' order by colno;<br />
output to c:\#rps_500_temp.txt<br />
<br />

</div>


Sorry I couldnot find out any...
I was planning to use the foll command as of now...

select cname,coltype,length,nulls from sys.syscolumns where tname='#rps_500_temp' order by colno;
output to c:\#rps_500_temp.txt



<div>
That won't give you the SQL but it's a good start. 8-) 
</div>


That won't give you the SQL but it's a good start. 8-)

<div>
<div class="content wysiwyg-content">
I created a table with 150 columns using interface in ASA9. Now my DBA wants the SQL of CREATE TABLE.<br />
I dont have time to code and give him the SQL as every column name is lengthy too.<br />
Also I may add, 40 more columns in future.<br />
Is there anyway, I can generate SQL for my existing table ? Kindly help...<br />
Thanks<br />
M
</div>
</div>


I created a table with 150 columns using interface in ASA9. Now my DBA wants the SQL of CREATE TABLE.
I dont have time to code and give him the SQL as every column name is lengthy too.
Also I may add, 40 more columns in future.
Is there anyway, I can generate SQL for my existing table ? Kindly help...
Thanks
M

Generating SQL using ASA9

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.