Specifying a Partition Strategy Using select...into

The partitions_clause, when used with select...into, allows you to specify the partition properties of the table created by the command. If you do not specify a partition type, the SAP ASE server creates an unpartitioned table. If any row to be inserted does not satisfy the criteria for any partition in the target table, select...into fails.