Manually generate create table

Database

Manually generate create table

Hi All,

I'm looking for a way to manually generate create table (as another table) script. 

The output should be script because I need to edit it.

My final goal is to create table (regular table without columnar) as columnar table.

Can anyone please assist?

Thanks,

Noa.

2 REPLIES
Junior Contributor

Re: Manually generate create table

Define "manually generate".

There's CREATE TABLE newtable AS existingtable..., which allows defining indexes.

Or SHOW TABLE and then edit.

Re: Manually generate create table

Hi Dieter,

Thanks for your quick replay :)

I'll explain my situation.

We're using Teradata 14.10 and currently changing some prod tables schema to columnar.

In order not to harm our business logic we have continue importing daily data from multiload into staging table. This staging table has to be without columnar (with SET option and PI).

My main goal is to run daily script which drop and create the staging table as the prod table but with some schema changes (without the columnar features).

Thanks,

Noa.