DBCode - Docs - Row Limit

Find out how to set a specific row limit when opening a table.

Select a Connection

In the DB Explorer pane, begin by selecting a database connection.

Choose a Database

After selecting connection, select the desired database from the list.

Selecting a database — Select the database containing your target table

Locate and Select a Table

Expand the Tables section, then hover over the table you want to view.

Open the Table with a Row Limit

Right-click on the selected table and choose Open with Limit from the context menu as shown below.

Open with limit option — Use the context menu to open a table with a custom row limit

Specify Row Limit

There is a default limit of 100,000 rows. This can be adjusted in Settings, or changed as needed needed to fetch the desired number of rows. Once you’ve made your selection, press Enter.

Enter row limit — Specify the number of rows you want to retrieve

The table will open in a new tab with only the specified number of rows displayed.

Table with row limit — View your table with the custom row limit applied