Top "Unique-index" questions

How do I delete all the duplicate records in a MySQL table without temp tables

I've seen a number of variations on this but nothing quite matches what I'm trying to accomplish. I have a …

mysql sql duplicates sql-delete unique-index

Short unique id in php

I want to create a unique id but uniqid() is giving something like '492607b0ee414'. What i would …

php uniqueidentifier unique-index

Unable to create index because of duplicate that doesn't exist?

I'm getting an error running the following Transact-SQL command: CREATE UNIQUE NONCLUSTERED INDEX IX_TopicShortName ON DimMeasureTopic(TopicShortName) The error …

sql-server-2005 tsql indexing unique-index

Removing duplicates with unique index

I inserted between two tables fields A,B,C,D, believing I had created a Unique Index on A,B,…

mysql duplicates unique-index

how to set a column as unique indexer on Sqlite

I have 3 columns (_id, column1, column2) _id column has been set as autoincrement In database there are some duplicate records, …

android sqlite unique-index

Enforcement of unique/primary key - drop index

I am trying to drop an index : DROP INDEX PK_CHARGES but I get this error cannot drop index used …

oracle primary-key unique-index

Unique index or unique key?

What is the diffrence between a unique index and a unique key?

sql-server database-design unique-constraint unique-index

Can not drop UNIQUE index from table

When I run this query ALTER TABLE "dbo"."ROOM" DROP INDEX "UNIQUE"; I got this message: Error 1018: Incorrect syntax near …

sql sql-server unique-index

Add unique index. SQLite3

I need to add a unique field index to an existing table. I made this row: ALTER TABLE auth_user …

sql sqlite ddl unique-index

Unique Constraint vs Unique Index

I’m interested in learning which technique developers prefer to use to enforce uniqueness in SQL Server: UNIQUE CONSTRAINT or …

sql-server database-design unique-constraint unique-index