All Forums Database
Edo_Ram 2 posts Joined 07/13
24 Jul 2013
Change columns order

How can i change the columns order on a table??
or
How can i insert a new column after other ??
 
sample
ALTER TABLE <TABLE.NAME> ADD COLUM <NAME.COLUMN> <DATA.TYPE> AFTER <NAME.COLUMN>
 
hope that i explain well

dnoeth 4628 posts Joined 11/04
24 Jul 2013

You can't do that.
Why do you think you need it? Teradata is a Relational database and the order of columns has no relevane in Relational Model.
You might simply change the 1:1 view for this table to use the new order.
Btw, writing "SELECT *" in SQL is bad practice...
Dieter

Dieter

Edo_Ram 2 posts Joined 07/13
24 Jul 2013

Thank's for the answer..

I know that Teradata is a relational database and what that means. but, a client ask me about that and i didn't know it, also i couldn't find so much information

again, thank you for take a moment and answer my question
 
Eduardo.

You must sign in to leave a comment.