 |
 |
Archives of the TeradataForum
Message Posted: Thu, 04 Dec 2003 @ 14:17:46 GMT
| Subj: | | Re: Table header |
| |
| From: | | Vivek Pandey |
Anomy Anom wrote:
| | When use alter table to add a coulmn --> ABC char(2) not null with default, will Teradata insert "blank" to each existing row,
or just modify the table header instead? | |
I write:
I think it will insert the blank to every row and is obvious from the below query after issuing the ALTER TABLE on t1.
sel char2hexint(abc),a,b,abc from t1;
Char2HexInt(ABC) a b ABC
2020 1 1
2020 1 11
2020 1 111
Thanks, Vivek.
| |
