CDbCriteria: Remove limit

I want to remove the limit option in the CDbCriteria. By default it has LIMIT 10. I want to display all the records from the particular table without any limit. For instance: SELECT * FROM tbl_name



Can any one suggest me how to remove it.

Thank you for help.

CDbCriteria::limit is by default -1… so I presume you are using CGridView or CListView and there you have by default pagination with 10 records by default…

To disable that set the pagination of the CActiveDataProvider to false -

Thank you friends. :)