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
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…