Member Avatar for dipakatcvrca

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
  • 5K Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by faucon
Member Avatar for dipakatcvrca

Thanks friend for the solution. Enjoy your time. :)

Member Avatar for faucon

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.