Skip to Content
0
Former Member
Aug 23, 2016 at 11:33 AM

How to create HDB Table from any other catalog table/view.

1328 Views

I want to create a HDB Table which will have same table structure as that of one of my catalog table. Is there a way to directly create it as we create one catalog table from another catalog table. Eg:

CREATE COLUMN TABLE "ABC" AS (SELECT * FROM "XYZ");

The manual way to create HDB table is time consuming.