0

Hi All,

While going through my project work, I just came across a situation, where I needed to alter my table. I needed to add a column at the beginning of the table, i.e. the first column of the table. We have syntax for appending a column to a table by simple "ALTER TABLE.." syntax, or we can append a column after any particular row by using "AFTER" key word. But my need is to add the column right at the beginning of the table.
Hope fully I have explained my issue properly, now I am expecting somebody to answer my question. Any effort to fix the issue is appreciable.

Thanks

Dipak

3
Contributors
3
Replies
7
Views
6 Years
Discussion Span
Last Post by faucon
0

DE SINTAX TO ADD email a de start of de table contact is:
ALTER TABLE contacts ADD email VARCHAR(60) FIRST;

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.