Hi,

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

jerusha
0224
accept rate: 0%


Select * from systable

permanent link

answered 02 Mar '12, 05:35

Martin's gravatar image

Martin
8.6k116151237
accept rate: 14%

thank you ...

SELECT table_name=sysobjects.name, column_name=syscolumns.name FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id inner join systypes on syscolumns.type=systypes.type where sysobjects.type='U' order by sysobjects.name,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

jerusha
0224
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

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:

×12

question asked: 02 Mar '12, 04:37

question was seen: 721 times

last updated: 02 Mar '12, 07:10