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.

Table Script

3 posts in General Discussion Last posting was on 2003-06-20 01:41:52.0Z
Bhoj Rawal Posted on 2003-06-18 18:47:31.0Z
Reply-To: "Bhoj Rawal" <brawal@tenmast.com>
From: "Bhoj Rawal" <brawal@tenmast.com>
Subject: Table Script
Date: Wed, 18 Jun 2003 14:47:31 -0400
Lines: 9
Organization: Tenmast
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <ust5WscNDHA.339@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 216.248.59.166
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1215
Article PK: 3459

How do I create a script for the individual table?
I know we have Unload database options but I am talking about tables and
related indexes and all other entities related to that table.

Thanks
-Bhoj


Shuchit Velkar Posted on 2003-06-20 01:41:52.0Z
Subject: Re: Table Script
From: Shuchit Velkar <xxx@xxx.net>
References: <ust5WscNDHA.339@forums-2-dub>
Message-ID: <Xns939FDB762C617svelkarNOsybaseSPAMc@10.22.241.106>
User-Agent: Xnews/5.04.25
Newsgroups: ianywhere.public.general
Date: Thu, 19 Jun 2003 18:41:52 -0700
NNTP-Posting-Host: vpn-concord-089.sybase.com 158.159.8.89
Lines: 20
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1220
Article PK: 3461

"Bhoj Rawal" <brawal@tenmast.com> wrote in news:ust5WscNDHA.339@forums-2-
dub:

> How do I create a script for the individual table?
> I know we have Unload database options but I am talking about tables and
> related indexes and all other entities related to that table.
>
> Thanks
> -Bhoj
>
>
>
>

Most versions of SQL Anywhere Studio ship with PowerDesigner
It was called Physical Architect in Asa 7.x

It will let you reverse engineer your database and then selectively
export table definition, constraints, indexes, foreign keys, custom
datatypes, triggers, etc for one or more tables.

--
Shuchit Velkar
iAnywhere Solutions
Professional Services
Please only post to the newsgroup

EBFs and Whitepapers
http://www.ianywhere.com/developer


Robert Waywell Posted on 2003-06-19 14:31:02.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <ust5WscNDHA.339@forums-2-dub>
Subject: Re: Table Script
Date: Thu, 19 Jun 2003 10:31:02 -0400
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <eG#U0BnNDHA.279@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1219
Article PK: 3464

You can either use dbunload, then edit out the pieces you don't need, or you
could simply write a script.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Bhoj Rawal" <brawal@tenmast.com> wrote in message
news:ust5WscNDHA.339@forums-2-dub...
> How do I create a script for the individual table?
> I know we have Unload database options but I am talking about tables and
> related indexes and all other entities related to that table.
>
> Thanks
> -Bhoj
>
>
>