The active partition is the main partition of the hard drive that has a Windows operating system and it can be set as a bootable partition. On every hard drive, you can pick only one primary partition ...
* Function to drop child tables from an id-based partition set. * Options to move table to different schema or actually drop the table from the database.
-- So cannot create the child table when only some of the data has been moved out of the default partition. RAISE EXCEPTION 'If any interval smaller than the partition interval must be used for moving ...