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.

Enterprise Explorer -- Table Editor

2 posts in General Discussion Last posting was on 2008-03-24 05:11:45.0Z
Andreas Gerats Posted on 2008-03-20 09:37:56.0Z
Sender: 3735.47e22a28.1804289383@sybase.com
From: Andreas Gerats
Newsgroups: sybase.public.workspace.general
Subject: Enterprise Explorer -- Table Editor
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47e23074.37c4.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Mar 2008 01:37:56 -0800
X-Trace: forums-1-dub 1206005876 10.22.241.41 (20 Mar 2008 01:37:56 -0800)
X-Original-Trace: 20 Mar 2008 01:37:56 -0800, 10.22.241.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:643
Article PK: 1088313

Hi,

when I create a new table, I am able to move columns up and
down. That is very convenient and ergonomic since I can
arrange columns in some logic sequence and I can easily
build a primary key. Saving the file with checking "create
script ..." and the suggestion of WorkSpace for file name
<tablename>.sql is fine.

After creating the table physically there is no more
possibility inside WorkSpace to move columns up and down.
This is not convenient anymore. When primary key in table
expands, I will not be able to group pk columns together, I
will have to drop the table, arrange the columns in ddl
script and recreate the table outside WorkSpace.
Furthermore when I am going to save the ddl script to the
file created above, WorkSpace suggests a different file name
as above, namely <tablename>_ddl.sql with _ddl added.

Thx and best regards
Andreas


Daniel Huang Posted on 2008-03-24 05:11:45.0Z
Reply-To: "Daniel Huang" <lihuang@sybase.com>
From: "Daniel Huang" <lihuang@sybase.com>
Newsgroups: sybase.public.workspace.general
References: <47e23074.37c4.1681692777@sybase.com>
Subject: Re: Enterprise Explorer -- Table Editor
Lines: 46
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47e73811@forums-1-dub>
Date: 23 Mar 2008 21:11:45 -0800
X-Trace: forums-1-dub 1206335505 10.22.241.152 (23 Mar 2008 21:11:45 -0800)
X-Original-Trace: 23 Mar 2008 21:11:45 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:652
Article PK: 1088327

Hi, Andreas:

After the table is created, the column is allowed to be added and dropped.
To move up/down column, it requires to drop table and recreate it, but it
will lose table data. So WorkSpace doesn't support moving up/down columns
in table schema editor.


--
Thanks and regards,

Daniel Huang

Sybase Software (China) Co., Ltd
Room 1202-1203, Building One,
Zhangjiang Semiconductor Industry Park
3000 Longdong Avenue
Pudong, Shanghai 201203
Email: lihuang@sybase.com

<Andreas Gerats> wrote in message
news:47e23074.37c4.1681692777@sybase.com...
> Hi,
>
> when I create a new table, I am able to move columns up and
> down. That is very convenient and ergonomic since I can
> arrange columns in some logic sequence and I can easily
> build a primary key. Saving the file with checking "create
> script ..." and the suggestion of WorkSpace for file name
> <tablename>.sql is fine.
>
> After creating the table physically there is no more
> possibility inside WorkSpace to move columns up and down.
> This is not convenient anymore. When primary key in table
> expands, I will not be able to group pk columns together, I
> will have to drop the table, arrange the columns in ddl
> script and recreate the table outside WorkSpace.
> Furthermore when I am going to save the ddl script to the
> file created above, WorkSpace suggests a different file name
> as above, namely <tablename>_ddl.sql with _ddl added.
>
> Thx and best regards
> Andreas