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.

Comments in CREATE TABLE

2 posts in General Discussion Last posting was on 2013-03-01 11:26:39.0Z
RGS Posted on 2013-02-28 22:31:38.0Z
Sender: 6f58.512fd9fd.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Comments in CREATE TABLE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <512fdac9.6fb8.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 28 Feb 2013 14:31:38 -0800
X-Trace: forums-1-dub 1362090698 172.20.134.41 (28 Feb 2013 14:31:38 -0800)
X-Original-Trace: 28 Feb 2013 14:31:38 -0800, 172.20.134.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31716
Article PK: 1308015

Hi!

I am using Sybase 15.7

Is it possible to save comments for each field when I am
creating a table via CREATE TABLE command?

My idea is, when a person execute "sp_help" command for a
table, he can view the structure of the table and the
comments of each field

Thanks!!!


Rob V Posted on 2013-03-01 11:26:39.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130215 Thunderbird/17.0.3
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Comments in CREATE TABLE
References: <512fdac9.6fb8.1681692777@sybase.com>
In-Reply-To: <512fdac9.6fb8.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <5130906f@forums-1-dub>
Date: 1 Mar 2013 03:26:39 -0800
X-Trace: forums-1-dub 1362137199 172.20.134.152 (1 Mar 2013 03:26:39 -0800)
X-Original-Trace: 1 Mar 2013 03:26:39 -0800, vip152.sybase.com
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31717
Article PK: 1308022


On 28-Feb-2013 23:31, RGS wrote:
> Hi!
>
> I am using Sybase 15.7
>
> Is it possible to save comments for each field when I am
> creating a table via CREATE TABLE command?
>
> My idea is, when a person execute "sp_help" command for a
> table, he can view the structure of the table and the
> comments of each field
>
> Thanks!!!
>

This is not possible by default. See http://www.sybase.com/detail?id=607
for a way to record comments in the catalogs, but you will have to enter
the comments separately.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------