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 scripts

3 posts in General Discussion Last posting was on 2004-04-08 13:25:25.0Z
sen Posted on 2004-04-07 13:17:17.0Z
Sender: 2fc0.4073f05d.1804289383@sybase.com
From: Sen
Newsgroups: ianywhere.public.general
Subject: generating sql scripts
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <4073f14d.2fcb.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Apr 2004 05:17:17 -0800
X-Trace: forums-1-dub 1081340237 10.22.241.41 (7 Apr 2004 05:17:17 -0800)
X-Original-Trace: 7 Apr 2004 05:17:17 -0800, 10.22.241.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2934
Article PK: 6404

how to get sql scripts create table structure from a table ,
in sql server we simple rights click the table and choose
sql scripts, is there any simple way to do this ? I had
tried looking at documentation manual but no success

Please forgive me if this had been post before

Sen
TIA


David Fishburn Posted on 2004-04-07 13:40:14.0Z
Newsgroups: ianywhere.public.general
Subject: Re: generating sql scripts
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <4073f14d.2fcb.846930886@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns94C45831EBA51fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
NNTP-Posting-Host: vpn-concord-126.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-126.sybase.com
Date: 7 Apr 2004 05:40:14 -0800
X-Trace: forums-1-dub 1081341614 158.159.8.126 (7 Apr 2004 05:40:14 -0800)
X-Original-Trace: 7 Apr 2004 05:40:14 -0800, vpn-concord-126.sybase.com
Lines: 39
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2935
Article PK: 6405

Sen wrote in news:4073f14d.2fcb.846930886@sybase.com:

S> how to get sql scripts create table structure from a table ,
S> in sql server we simple rights click the table and choose
S> sql scripts, is there any simple way to do this ? I had
S> tried looking at documentation manual but no success

There are 2 ways in ASA 9.x.
In Sybase Central, right click on a table and choose "Copy".
Then open notepad.exe and choose "Paste".

Or, to do all the tables run:
dbunload -c ... -n (no data)

This will create a file called reload.sql with all the statements
necessary to rebuild your database. Included in those are all the
CREATE TABLE statements.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


sen Posted on 2004-04-08 13:25:25.0Z
Sender: 8e0.40754416.1804289383@sybase.com
From: Sen
Newsgroups: ianywhere.public.general
Subject: Re: generating sql scripts
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <407544af.8f0.846930886@sybase.com>
References: <4073f14d.2fcb.846930886@sybase.com><Xns94C45831EBA51fishburnsybasecom@10.22.241.106>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 8 Apr 2004 05:25:19 -0800, 10.22.241.42
Lines: 3
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Apr 2004 05:25:20 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Apr 2004 05:25:25 -0800
X-Trace: forums-1-dub 1081427125 10.22.108.75 (8 Apr 2004 05:25:25 -0800)
X-Original-Trace: 8 Apr 2004 05:25:25 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2941
Article PK: 6410

David, many thanks.

Sen