Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.


I need to fetch all table records from database.

Example : i have 7 table in database.. in future one more table may be add. so , i need to connect the db and fetch all tables value(columns and rows).

could you please tell me query.

thanks, jeru

asked 02 Mar '12, 04:37

jerusha's gravatar image

accept rate: 0%

Select * from systable

permanent link

answered 02 Mar '12, 05:35

Martin's gravatar image

accept rate: 14%

thank you ...

SELECT, FROM sysobjects INNER JOIN syscolumns ON = inner join systypes on syscolumns.type=systypes.type where sysobjects.type='U' order by,syscolumns.colid

which will give the below result.

Table_name column_name A xxx A xyz

I need

Database_name table_name column_name

Reply Forward

permanent link

answered 02 Mar '12, 05:56

jerusha's gravatar image

accept rate: 0%

Are you using Sybase Adaptive Server Enterprise (ASE)? The query looks like that.

Note, this forum is for Sybase SQL Anywhere, a completely different DBMS...

(02 Mar '12, 06:45) Volker Barth
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: 02 Mar '12, 04:37

question was seen: 2,350 times

last updated: 02 Mar '12, 07:10