top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What is ALTER command? How we use it to Add a new column?

+1 vote
87 views
What is ALTER command? How we use it to Add a new column?
posted Jul 24, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

ALTER command is used to modify the structure of table. By using alter we can add, modify & delete columns. to change the data type or decrease the size of a column the column must be empty. For ALTER a table we need ALTER, INSERT & CREATE privileges.
Ex: ALTER table

ADD type(size);
answer Jul 27, 2015 by Arun Gowda
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...