Sublime Forum

Sublime not returning all rows in query

#1

select top 100 id from table_name;

rows returned: 100
id
1
2
3
4
5
6
7
8
9
10

all of my queries only show a max of 10 rows returned. How do I get it to show all expected rows returned?

0 Likes

#2

How is this related to Sublime Text?

0 Likes

#3

because sublime text is limiting the rows returned in the query window.

0 Likes

#4

found my answer- add this line to the sublime settings “rows_per_sql_table”: 1000

0 Likes

#5

You don’t even provide enough context so that people can help.

4 Likes