Bigger column and Delete Unique

Question

Hi In mysql server what is the query to solve the problem -: How to make a column bigger and Delete unique from table. Thanks

Arjun Panwar · Answer

Hi Aarti Thanks for reply but this is not sufficient for me. Jimmy send the reply and this is correct.so you also check it. thanks

Jimmy Underwood · Answer

Hi Arjun Panwar I think you find it mysql> alter table [table name] drop column [column name]; mysql> alter table [table name] add column [new column name] varchar (20); Thanks

Aarti · Answer

1. How to make a column bigger : as i assume Column bigger  increase the size of column for this Define column as nvarchar(max) 2. Delete unique from table. : ALTER TABLE table_name DROP INDEX col_name;

Arjun Panwar · Answer

Hello Aarti my question is 1. How to make a column bigger 2. Delete unique from table.

Aarti · Answer

HI Arjun Please Elaborate your question in detail.