Question Re: DB query help in Technology Q&A

DB query help

Former Member — Fri, 02 Mar 2012 04:37:26 GMT

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

Re: DB query help

MCMartin — Fri, 02 Mar 2012 05:35:41 GMT

Select * from systable

Re: DB query help

Former Member — Fri, 02 Mar 2012 05:56:31 GMT

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

Re: DB query help

VolkerBarth — Fri, 02 Mar 2012 06:45:03 GMT

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