|
Replies:
7
-
Pages:
1
-
Last Post:
Sep 25, 2011 10:15 AM
Last Post By: zaj
|
|
|
Posts:
38
Registered:
09/21/11
|
|
|
|
New to DbVis
Posted:
Sep 22, 2011 7:04 AM
|
|
|
|
Hello there,
How can i turn off the Max Row detault to 1000. i mean i want DbVis to return all the rows in my table when i click on the data tab.
Also I want toknow is there some settings which will allow me to see the primary keys indicated in the left hand side.i mean when i open the table in the tree view,it shows me the col names but does not show which of the cols are pk and fk. for e.g. if you see SSMS,when you browse open the table it shows you the PKs and FKs. ihave attached the screenshot of SSRS.
cheers
Zolf
|
|
Posts:
4,566
Registered:
12/17/04
|
|
|
|
Re: New to DbVis
Posted:
Sep 22, 2011 9:08 AM
in response to: zaj
|
|
|
|
|
|
Zolf,
Please check the attached screenshots how to set Max Rows.
Browsing primary/foreign keys for each table in the objects tree is currently not possible. I'll register this as a RFE.
Thanks!
Regards
Roger
|
|
Posts:
38
Registered:
09/21/11
|
|
|
|
Re: New to DbVis
Posted:
Sep 23, 2011 7:16 AM
in response to: Roger Bjarevall
|
|
|
|
Roger,
Thanks for your comment. What you mentioned is to set it manually and some of my tables have more then 100,000 records,so do i need to enter this number everytime.i want to be able to disable this feature to anly allow specific number of rows to be returned.is there is the settings to be able to disable it. also i can have a situation that i dont know how much row the table has,for e.g. i might enter 1,000,000 but then i might have more then the typed number,so i will miss those rows.hope i made myself clear.by the way thanks for registrating that PK,FK feature in next version. it wil be helpful.
cheers
Zolf
|
|
Posts:
4,566
Registered:
12/17/04
|
|
|
|
Re: New to DbVis
Posted:
Sep 23, 2011 8:36 AM
in response to: zaj
|
|
|
|
Zolf,
To handle an unlimited number of rows enter 0. Note however that this is not recommended since it may result in out of memory situations. If you would like to fetch all rows in a million row table then I suggest you export it using the Export Table feature (available in the licensed DbVisualizer Personal edition).
Regards
Roger
|
|
Posts:
38
Registered:
09/21/11
|
|
|
|
Re: New to DbVis
Posted:
Sep 25, 2011 8:49 AM
in response to: Roger Bjarevall
|
|
|
|
Roger,
thanks.by the way i have a licence copy of DbVis and want to know were do lic copy users ask their questions.
cheers
Zolf
|
|
Posts:
38
Registered:
09/21/11
|
|
|
|
Re: New to DbVis
Posted:
Sep 25, 2011 8:55 AM
in response to: zaj
|
|
|
|
Roger,
do i need to enter that 0 in the Menu Tools -> Tools Properties --Table Data -- Max Rows at first display. i entered 0 therebut it shows me 10000 by default not all rows
|
|
Posts:
4,566
Registered:
12/17/04
|
|
|
|
Re: New to DbVis
Posted:
Sep 25, 2011 10:11 AM
in response to: zaj
|
|
|
|
Zolf,
If you enter 0 in Max Rows at First Display it means the setting is ignored.
Regards
Roger
|
|
Posts:
38
Registered:
09/21/11
|
|
|
|
Re: New to DbVis
Posted:
Sep 25, 2011 10:15 AM
in response to: Roger Bjarevall
|
|
|
|
Roger,
thanks.
|
|
|
|
