Is there one available somewhere for SQL Anywhere like there is for ASE? (v10.0.1)

asked 12 Dec '09, 02:19

Calvin%20Allen's gravatar image

Calvin Allen
accept rate: 25%

AFAIK there is no system tables poster for SQL Anywhere. It's an interesting idea, here are some random thoughts...

In an empty 11.0.1 database there are 111 base tables with 715 columns and 128 foreign keys. That doesn't include the MobiLink ml_* system tables which are interesting to a lot of people. It also doesn't include 29 global temporary system tables with 251 columns and 118 system views with 854 columns.

Why would anyone care about a system view? Well, for one thing, you cannot SELECT * FROM ISYSTAB (the system base table) but you have to SELECT * FROM SYSTAB (the system view).

The diagram should probably show the views (SYSTAB etc) because that's what people can use, and it should show the relationships among them (even though foreign keys don't actually exist among views).

That brings up another question: What the heck is SYSTAB? A lot of people only understand SYSTABLE which was the old pre-V10 name for the Number One System Table. Now, in V10 and V11, SYSTABLE is a legacy-backwards-compatibility view... should it be on the poster? Probably not.

Creating a poster would be a labor of love, the result would be a piece of art... never mind whether there's demand, I'm not sure there's an artist interested in creating it ( true artists don't need demand :)

permanent link

answered 12 Dec '09, 09:05

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 12 Dec '09, 02:19

question was seen: 2,684 times

last updated: 12 Dec '09, 09:05