SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2008
    Posts
    99
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    remove unique , primary property

    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 ?

    regards

  2. #2
    SitePοint Troll disgracian's Avatar
    Join Date
    Aug 2006
    Location
    Samsara
    Posts
    451
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

    Cheers,
    D.

  3. #3
    SitePoint Mentor bronze trophy
    John_Betong's Avatar
    Join Date
    Aug 2005
    Location
    City of Angels
    Posts
    1,889
    Mentioned
    74 Post(s)
    Tagged
    6 Thread(s)
    If you are using MySQL:
    load phpmyadmin
    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.




    .
    Learn how to be ready for The New Move to Discourse

    How to make Make Money Now with a *NEW* look

    Be sure to congratulate Wolfshade on earning Member of the Month for August 2014


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •