on 2012 Mar 02 4:37 AM
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
Request clarification before answering.
Select * from systable
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.