Archives of the TeradataForum

Message Posted: Mon, 13 Feb 2006 @ 20:31:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You can create all the ALTER TABLE statements you want without raising a sweat.

In SQL Assistant:

     SELECT
             DatabaseName,
             TableName,
             ColumnName,
             ColumnFormat
     FROM DBC.Columns
     WHERE DatabaseName IN ('whatever','whatever');

Copy/paste results into Excel

Sort by columnformat

Create a new column in your spreadsheet with the (default) formats you really want

Copy/paste spreadsheet contents into a good text editor (like TextPad)

Build a one-off macro to build ALTER TABLE statements from the tab-delimited fields

Copy/paste into SQL Assistant & run

Drink some coffee

I admit this solution is pure duct tape. But like I said, why sweat it?

	<Prev	Next>		<<First	<Prev	Next>	Last>>