SqlDbx
You are not logged in.
Pages: 1
Hi,
sometimes in the business world we all come across databases we are not particularly familiar with since we didn't create them. The fastest way to initially get to know the database is to select few rows from couple of tables, right?
Well some sql editors have this handy feature, my idea is this - somewhere in menues place an option "Turn table preview on/off", and after it has been turned on you can click on any table on object list (or select first table and scroll down with arrow down) and get "select *" result in result grid (only first 100 rows or such).
As I understood, so far there is only "select *" option when we right-click each table.
Let me know if this makes any sence to you guys..
Regards,
Goran
Offline
You can do something like this right now.
In Options->Results set Rows Limit to a number of rows you want to retrieve.
Then on a main toolbar press a button "Limit number of returned rows" which located before "Execute button".
Now any query you execute will only return number of rows you set in Options->Results.
Offline
I'm aware of this limit rows feature and that's fine.
But you have to write code and change table names for each table you would like to preview.
select * from table1
select * from table2
select * from table3
select * from table4
select * from table5
My suggestion was that you somehow enable this "select *" mode and simply start clicking on table names located in object list and preview rows in result grid, much quicker.
Just a thought..
Anyway, thanks for your answer.
Goran
Offline
I see now what you mean. This can be a little confusing.
Offline
Pages: 1