Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Generating SQL from ASA9

2 posts in General Discussion Last posting was on 2006-07-07 19:47:46.0Z
Mahalakshmi Santhanam Posted on 2006-07-07 17:04:47.0Z
From: "Mahalakshmi Santhanam" <mahamitty@yahoo.com>
Newsgroups: ianywhere.public.answersanywhere.general
Subject: Generating SQL from ASA9
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 12.107.137.134
X-Original-NNTP-Posting-Host: 12.107.137.134
Message-ID: <44ae942f$1@forums-1-dub>
Date: 7 Jul 2006 10:04:47 -0700
X-Trace: forums-1-dub 1152291887 12.107.137.134 (7 Jul 2006 10:04:47 -0700)
X-Original-Trace: 7 Jul 2006 10:04:47 -0700, 12.107.137.134
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.answersanywhere.general:31
Article PK: 29

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


Stephen Rice Posted on 2006-07-07 19:47:46.0Z
From: "Stephen Rice" <sriceATianywhereDOTcom>
Newsgroups: ianywhere.public.answersanywhere.general
References: <44ae942f$1@forums-1-dub>
Subject: Re: Generating SQL from ASA9
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: srice-xp2.sybase.com
Message-ID: <44aeb8fd$1@forums-2-dub>
X-Original-Trace: 7 Jul 2006 12:41:49 -0700, srice-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 Jul 2006 12:41:51 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 Jul 2006 12:47:46 -0700
X-Trace: forums-1-dub 1152301666 10.22.108.75 (7 Jul 2006 12:47:46 -0700)
X-Original-Trace: 7 Jul 2006 12:47:46 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.answersanywhere.general:33
Article PK: 8

Hi

You should post future SQL Anywhere questions to the newsgroup
sybase.public.sqlanywhere.general This group is for our Answers Anywhere
product

the dbunload utility will generate the CREATE TABLE SQL for you. you may
want to use the -n and -t switches

--
/steve

Stephen Rice
Technical Services Manager
iAnywhere (a Sybase Company)
email: srice@ianywhere.com

* Register now for TechWave 2006 August 6-10 in Las Vegas Join us for
detailed product training tracks on Afaria, RemoteWare, OneBridge, SQL
Anywhere and Advantage Database. Visit www.sybase.com/techwave

"Mahalakshmi Santhanam" <mahamitty@yahoo.com> wrote in message
news:44ae942f$1@forums-1-dub...
>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
>