Syntax: 

CHECK TABLE table-name ORDER BY expr [ sort-order ]

sort-order:
[ COLLATE collation-name ] [ ASC | DESC ]
	

This command checks whether the table is sorted according to the specified expressions and stores the result. A table can be sorted according to one condition only. If a CREATE TABLE ... AS SELECT ... ORDER BY was used to create the table, then it is not necessary to use the CHECK TABLE command.