Is there a way to get a description of a table or database object in isql besides copy/paste from sybase central? If I recall there is something similiar in MySQL, like DESC.

asked 30 Dec '10, 20:27

zippidydo's gravatar image

zippidydo
377151521
accept rate: 0%


DESCRIBE [ [ INDEX FOR ] TABLE | PROCEDURE ] [ owner.]object-name

object-name: table, view, materialized view, procedure, or function

permanent link

answered 31 Dec '10, 10:10

Vincent%20Buck's gravatar image

Vincent Buck
70681520
accept rate: 15%

2

Note that this is only available through dbisql. It is not a SQL statement.

(03 Jan '11, 19:49) Graeme Perrow

If your using SA 11.0.1 or above, you can also use sa_get_table_definition(). See: http://dcx.sybase.com/index.html#1101en/dbreference_en11/sa-get-table-definition-sysproc.html

permanent link

answered 04 Jan '11, 14:36

Bruce%20Hay's gravatar image

Bruce Hay
2.6k1510
accept rate: 48%

edited 04 Jan '11, 14:57

Volker%20Barth's gravatar image

Volker Barth
30.3k300452659

Just wanted to test this fine enhancement, and - oops, - "procedure not found", as my SA 11.0.1 production database hasn't been reloaded from V11.0.0, so the proc isn't available. (Yes, I could upgrade the database.)

(04 Jan '11, 15:00) Volker Barth

Besides Vincent's suggestion, you can always query the system catalog to get information about any kind of database object.

For views, procedures and functions, this will also allow to get the description (i.e. the source code) and not just the list of columns/parameters as DESCRIBE does.

As you can use regular SQL queries to query the system catalog, you're free to select and join those system tables/views to extract every detail you're interested in.

Here's a good starting point in the V12 docs.

This question shows some examples, too.

permanent link

answered 02 Jan '11, 15:02

Volker%20Barth's gravatar image

Volker Barth
30.3k300452659
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×27

question asked: 30 Dec '10, 20:27

question was seen: 1,173 times

last updated: 04 Jan '11, 14:57