cancel
Showing results for 
Search instead for 
Did you mean: 

derived table query size limit 65KB?

Former Member
0 Kudos

Hi. When in Edit Derived Table, if I paste a query larger than about 65KB, the end of the query will be cut off. Then I must create multiple Derived Tables. Has anyone else experienced this? Do you find the limit to be about 65KB?

Thanks,

Mike

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi ,

There is limitation to SQL query size for derived table . we can't use more than 64k .. better you can create the view in database using your long query ,instead of the derived table.

Thanks

Ponnarasu