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 |
Select * from systable |
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 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
|