cancel
Showing results for 
Search instead for 
Did you mean: 

DB query help

Former Member
0 Kudos
2,612

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

Accepted Solutions (0)

Answers (2)

Answers (2)

MCMartin
Participant

Select * from systable

Former Member
0 Kudos

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

VolkerBarth
Contributor
0 Kudos

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...