Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: New to DbVis

This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 7 - Pages: 1 - Last Post: Sep 25, 2011 10:15 AM Last Post By: zaj
zaj

Posts: 39
Registered: 09/21/11
New to DbVis
Posted: Sep 22, 2011 7:04 AM
 
   thread.click_reply Reply
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
Roger Bjarevall


Posts: 5,087
Registered: 12/17/04
Re: New to DbVis
Posted: Sep 22, 2011 9:08 AM    global.in_response_to.tooltip in response to: zaj
 
   thread.click_reply Reply
 global.attachment sqlcommander.png (54.5 KB )
 global.attachment datatab.png (71.1 KB )
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
zaj

Posts: 39
Registered: 09/21/11
Re: New to DbVis
Posted: Sep 23, 2011 7:16 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
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
Roger Bjarevall


Posts: 5,087
Registered: 12/17/04
Re: New to DbVis
Posted: Sep 23, 2011 8:36 AM    global.in_response_to.tooltip in response to: zaj
 
   thread.click_reply Reply
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
zaj

Posts: 39
Registered: 09/21/11
Re: New to DbVis
Posted: Sep 25, 2011 8:49 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
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
zaj

Posts: 39
Registered: 09/21/11
Re: New to DbVis
Posted: Sep 25, 2011 8:55 AM    global.in_response_to.tooltip in response to: zaj
 
   thread.click_reply Reply
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
Roger Bjarevall


Posts: 5,087
Registered: 12/17/04
Re: New to DbVis
Posted: Sep 25, 2011 10:11 AM    global.in_response_to.tooltip in response to: zaj
 
   thread.click_reply Reply
Zolf,

If you enter 0 in Max Rows at First Display it means the setting is ignored.

Regards

Roger
zaj

Posts: 39
Registered: 09/21/11
Re: New to DbVis
Posted: Sep 25, 2011 10:15 AM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
Roger,

thanks.

Point your RSS reader here for a feed of the latest messages in all forums