SQL table editor show only 100 rows

Hi Marco,

You have two options to achieve your goal, but neither will allow you to edit the records—only to view them:

1. Using a Grid View instead of a SQL Table Editor is the easiest option. The downside is that you cannot edit records in a Grid View. However, you can limit the number of rows in your data adapter.
   
   
2. I’d say this option is a bit more creative. If your table is in the application database, you can create a view to limit the number of rows. Then, in your SQL Table Editor, you can use that view in the WHERE clause.

In this example, I'm creating a View based on the Member table. Notice that I'm adding the Row_Number field which will help you limit the output:

CREATE VIEW MemberView AS SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNum FROM Member;

Then, in your SQL Table Editor, you need to query the View and use the Row_Number in the Where Clause:

Hope this helps!