Aqua Data Studio 14.0.8
Build #: 35460
Built on: 2014-Jan-09 08:51:14 AM
Database: Teradata Aster 6
Windows 7:64 bit
Step 1: Connect to Teradata Aster 6
Step 2: Create a table having column with text datatype.
CREATE TABLE "public"."text_table" (
"col1" varchar(25) NULL,
"col2" int NULL,
"col3" text NULL
)
DISTRIBUTE BY REPLICATION
STORAGE ROW
GO
Step 3:
Right click on "text_table"
Select option "Tools"
Select option "ER Diagram Generator"
"ER Diagram Generator" window opened
Select "text_table"-> Click NEXT
ER diagram generated for "text_table"
Step 4:
Right click on ER diagram of "text_table"
Select "Properties" option
Table properties window opened
Step 5:
Try to make any changes in table (say, add column)
Switch to sql preview tab.
It gives error: /* Column 'col3': invalid length. */
Therefore, In ER diagram, we can not make any changes in table having "text" datatype.
This is because, Aster treats text datatype as varchar of undefined length.
@ivan: pls comment...