DESIGN_TABLES
Contains information about all the design tables for all the designs for which you are the owner. Each row contains information about a different design table. Vertica creates this table when you run DESIGNER_CREATE_DESIGN
.
Column Name | Column Type | Description |
---|---|---|
DESIGN_NAME
|
VARCHAR | Unique name that the user specified for the design. |
DESIGN_TABLE_ID
|
INTEGER | Unique ID that Database Designer assigned to the design table. |
TABLE_SCHEMA
|
VARCHAR | Name of the schema that contains the design table. |
TABLE_ID
|
INTEGER | System object identifier (OID) assigned to the design table. |
TABLE_NAME
|
VARCHAR | Name of the design table. |
Example
Add all the tables from the VMart database to the design VMART_DESIGN. This operation populates the DESIGN_TABLES
table:
=> SELECT DESIGNER_ADD_DESIGN_TABLES('VMART_DESIGN','online_sales.*'); DESIGNER_ADD_DESIGN_TABLES ---------------------------- 3 (1 row) => SELECT DESIGNER_ADD_DESIGN_TABLES('VMART_DESIGN','public.*'); DESIGNER_ADD_DESIGN_TABLES ---------------------------- 9 (1 row) => SELECT DESIGNER_ADD_DESIGN_TABLES('VMART_DESIGN','store.*'); DESIGNER_ADD_DESIGN_TABLES ---------------------------- 3 (1 row) => SELECT * FROM DESIGN_TABLES; design_name | design_table_id | table_schema | table_id | table_name -------------+-----------------+--------------+-------------------+----------------------- VMART_DESIGN | 1 | online_sales | 45035996373718754 | online_page_dimension VMART_DESIGN | 2 | online_sales | 45035996373718758 | call_center_dimension VMART_DESIGN | 3 | online_sales | 45035996373718762 | online_sales_fact VMART_DESIGN | 4 | public | 45035996373718766 | customer_dimension VMART_DESIGN | 5 | public | 45035996373718770 | product_dimension VMART_DESIGN | 6 | public | 45035996373718774 | promotion_dimension VMART_DESIGN | 7 | public | 45035996373718778 | date_dimension VMART_DESIGN | 8 | public | 45035996373718782 | vendor_dimension VMART_DESIGN | 9 | public | 45035996373718786 | employee_dimension VMART_DESIGN | 10 | public | 45035996373718822 | shipping_dimension VMART_DESIGN | 11 | public | 45035996373718826 | warehouse_dimension VMART_DESIGN | 12 | public | 45035996373718830 | inventory_face VMART_DESIGN | 13 | store | 45035996373718794 | store_dimension VMART_DESIGN | 14 | store | 45035996373718798 | store_sales_fact VMART_DESIGN | 15 | store | 45035996373718812 | store_orders_fact (15 rows)