mnask79 — 2010-05-03T03:15:35-04:00 — #1
hi all ,
i have table customers , and in this table there is 'username' field and its unique , and i want to remove this property , how can i please ?
disgracian — 2010-05-03T06:17:42-04:00 — #2
You really need to provide more information, such as what database you are using. Oracle, Postgres, MS SQL (aka SQL Server), MySQL (in which case this should be posted in the MySQL section), or other.
john_betong — 2010-05-03T06:21:27-04:00 — #3
If you are using MySQL:
select the database
select the table
select structure (tab at the top)
select details (link after the field details are displaye)
click on the little red icon to delete the index
Best to first practise on a copied table.