Skip to content
← dbForge Studio for SQL Server

How can we improve the product?

dbForge Studio for SQL Server: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Retrieve Data select top n rows

Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).

I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).

11 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
William Buchanan shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Hi,

    Thanks for your patience!

    Just want to inform you that the option "Database Explorer > General > Preferred Selection Size > Top n Rows" has been implemented.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  • Sebastián Golbert commented  ·   ·  Report

    Hi,

    I have the same problem. The pagination mode doesn't work as expected, I must edit the SQL query in order to preview big tables. This is done correctly in other inferior products like SSMS.

    Regards,
    Sebastian