0 - 2 of 2 tags for generate
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.

By eddie.yasi, 31 Jan 2013 | Tagged: generate ddl table studio multiset generated | 1 comment
Automatic Create Statistics Stored Procedures

Until you have Teradata V13 Statistics Wizard Easy Feature available for your Teradata installation, here is a set of stored procedures that will generate and/or run collect statistics statements based on a set of index, column and referential integrity rules.

By jdgraas, 07 Apr 2009 | Tagged: stored procedure collect statistics sysexecsql dynamic sql generate dba foreign key v_tools | 3 comments