Teradata Studio not generating correct DDL for table?

Tools & Utilities

Teradata Studio not generating correct DDL for table?

I'm using Teradata Studio v14.01.0.201206111225, and noticed that if I create a table as MULTISET, and later right-click the table, and in the Teradata sub-menu select Show DDL it correctly creates a CREATE MULTISET TABLE.... statement.

However, if I right-click the table and choose Generate DDL, the final statement generated is just CREATE TABLE...   I looked through the various options and didn't see anything to change that behavior.

Is that a bug with Generate DDL in Teradata Studio, or am I missing an option that will make it generate the proper DDL for a MULTISET table?

1 REPLY
Teradata Employee

Re: Teradata Studio not generating correct DDL for table?

Teradata Studio 14.01 does not generate all the elements of a table. Its DDL generator deals with parts of the table that are in its internal model of a table and that doesn't contain all of what can be defined.

The DDL generator of the 14.02 version of Studio will report the database's definition of the table. That version of Studio is coming soon.