Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » Data manipulation statements » Addition of data using INSERT

 

Advanced: Disk allocation for inserted rows

 SQL Anywhere stores rows contiguously, if possible
 SQL Anywhere may store rows in any order
 Space is not reserved for NULL columns
 Once inserted, rows identifiers are immutable
 A database file never shrinks
 See also