Database 316 Cloning a Database 316 Creating a Database with a Different Owner 316 Viewing the List of Databases 316 Altering a Database 317 Dropping a Database 317 Creating and Managing Tablespaces Defining a Date-Range Partitioned Table 352 Defining a Numeric-Range Partitioned Table 353 Defining a List Partitioned Table 354 Defining a Hash Partitioned Table 354 Defining a Multi-level Partitioned Table Creating a Date-Range Partitioned Table 370 Creating a Numeric-Range Partitioned Table 371 Creating a List Partitioned Table 371 Defining Multi-level Partitions 371 Partitioning an Existing Table 372 Partition

Database 552 Cloning a Database 553 Creating a Database with a Different Owner 553 Viewing the List of Databases 553 Altering a Database 554 Dropping a Database 554 Creating and Managing Tablespaces 582 Defining Date Range Table Partitions 582 Defining Numeric Range Table Partitions 583 Defining List Table Partitions 584 Defining Multi-level Partitions 584 Partitioning an Existing Table 585 Limitations correlated subquery 803 Example 2 – Correlated EXISTS subquery 803 Example 3 - CSQ in the Select List 803 Example 4 - CSQs connected by OR Clauses 803 Array Constructors 804 Row Constructors 805 VMware

Database 523 Cloning a Database 524 Creating a Database with a Different Owner 524 Viewing the List of Databases 524 Altering a Database 525 Dropping a Database 525 Creating and Managing Tablespaces 553 Defining Date Range Table Partitions 553 Defining Numeric Range Table Partitions 554 Defining List Table Partitions 554 Defining Multi-level Partitions 555 Partitioning an Existing Table 556 Limitations correlated subquery 774 Example 2 – Correlated EXISTS subquery 774 Example 3 - CSQ in the Select List 774 Example 4 - CSQs connected by OR Clauses 774 Array Constructors 775 Row Constructors 776 Expression

Database with a Different Owner 548 VMware Greenplum 6 Documentation VMware, Inc 22 Viewing the List of Databases 548 Altering a Database 548 Dropping a Database 549 Creating and Managing Tablespaces 576 Defining Date Range Table Partitions 577 Defining Numeric Range Table Partitions 578 Defining List Table Partitions 578 Defining Multi-level Partitions 578 Partitioning an Existing Table 579 Limitations correlated subquery 794 Example 2 – Correlated EXISTS subquery 794 Example 3 - CSQ in the Select List 795 Example 4 - CSQs connected by OR Clauses 795 Array Constructors 795 Row Constructors 796 Expression

Database 527 Cloning a Database 528 Creating a Database with a Different Owner 528 Viewing the List of Databases 528 Altering a Database 528 Dropping a Database 529 Creating and Managing Tablespaces 555 Defining Date Range Table Partitions 556 Defining Numeric Range Table Partitions 557 Defining List Table Partitions 557 Defining Multi-level Partitions 557 Partitioning an Existing Table 558 Limitations subquery 767 VMware Tanzu Greenplum 6 Documentation VMware, Inc 33 Example 3 - CSQ in the Select List 767 Example 4 - CSQs connected by OR Clauses 767 Array Constructors 768 Row Constructors 769 Expression

Database 524 Cloning a Database 525 Creating a Database with a Different Owner 525 Viewing the List of Databases 525 Altering a Database 525 Dropping a Database 526 Creating and Managing Tablespaces 552 Defining Date Range Table Partitions 553 Defining Numeric Range Table Partitions 554 Defining List Table Partitions 554 Defining Multi-level Partitions 554 Partitioning an Existing Table 555 Limitations correlated subquery 766 Example 2 – Correlated EXISTS subquery 766 Example 3 - CSQ in the Select List 766 Example 4 - CSQs connected by OR Clauses 767 Array Constructors 767 Row Constructors 768 VMware

Database 446 Cloning a Database 447 Creating a Database with a Different Owner 447 Viewing the List of Databases 447 Altering a Database 447 Dropping a Database 447 Creating and Managing Tablespaces 471 Defining Date Range Table Partitions 472 Defining Numeric Range Table Partitions 472 Defining List Table Partitions 473 Defining Multi-level Partitions 473 Partitioning an Existing Table 474 Limitations correlated subquery 662 Example 2 – Correlated EXISTS subquery 662 Example 3 - CSQ in the Select List 662 Example 4 - CSQs connected by OR Clauses 663 Array Constructors 663 Row Constructors 664 Expression

Database 725 Cloning a Database 725 Creating a Database with a Different Owner 726 Viewing the List of Databases 726 Altering a Database 726 VMware Greenplum v6.19 Documentation VMware, Inc. 41 43 Defining Date Range Table Partitions 754 Defining Numeric Range Table Partitions 755 Defining List Table Partitions 755 Defining Multi-level Partitions 755 Partitioning an Existing Table 756 Limitations correlated subquery 892 Example 2 – Correlated EXISTS subquery 892 Example 3 - CSQ in the Select List 892 Example 4 - CSQs connected by OR Clauses 893 Array Constructors 893 Row Constructors 894 Expression

Database 716 Cloning a Database 716 Creating a Database with a Different Owner 717 Viewing the List of Databases 717 Altering a Database 717 VMware Greenplum v6.18 Documentation VMware, Inc. 40 42 Defining Date Range Table Partitions 745 Defining Numeric Range Table Partitions 746 Defining List Table Partitions 746 Defining Multi-level Partitions 746 Partitioning an Existing Table 747 Limitations correlated subquery 883 Example 2 – Correlated EXISTS subquery 883 Example 3 - CSQ in the Select List 883 Example 4 - CSQs connected by OR Clauses 884 Array Constructors 884 Row Constructors 885 Expression

Database 714 Cloning a Database 714 Creating a Database with a Different Owner 715 Viewing the List of Databases 715 Altering a Database 715 Dropping a Database 715 Creating and Managing Tablespaces 743 Defining Date Range Table Partitions 743 Defining Numeric Range Table Partitions 744 Defining List Table Partitions 744 Defining Multi-level Partitions 744 Partitioning an Existing Table 745 Limitations correlated subquery 884 Example 2 – Correlated EXISTS subquery 884 Example 3 - CSQ in the Select List 884 Example 4 - CSQs connected by OR Clauses 885 Array Constructors 885 Row Constructors 886 Expression