sql unique
SELECT DISTINCT column1, column1, ..... FROM TABLE
/*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/
0
6
USE AdventureWorks2012;
GO
CREATE TABLE Production.TransactionHistoryArchive4
(
TransactionID int NOT NULL,
CONSTRAINT AK_TransactionID UNIQUE(TransactionID)
);
GO
Thank you!
6
0
0
3
1
This constraint ensures all values in a column are unique.
Example 1 (MySQL): Adds a unique constraint to the id column when
creating a new users table.
CREATE TABLE users (
id int NOT NULL,
name varchar(255) NOT NULL,
UNIQUE (id)
);
Example 2 (MySQL): Alters an existing column to add a UNIQUE
constraint.
ALTER TABLE users
ADD UNIQUE (id);
Thank you!
1
3
(1 Votes)
0
Are there any code examples left?
New code examples in category SQL
Relative searches
unique constraint sql server create table
distinct column sql
unique constraint in sql server
how to use unique constraint in sql
sqlserver unique constraint
how to create unique constraint in ms sql server
sql server distinct
unique constraint sql server
unique constraint in sql
select distinct sql
distinct sql server
tsql unique constraint
mssql unique
unique sql server
creating unique constraint in sql server
distinct records in sql
select distinct
alter table with unique constraint in sql server
get by unique value sql
distinct
sql server create table unique constraint example
unique in sql query
distinct query in sql
sql retrieve unique values
mysql distinct query
select query unique
get unique ids from sql and table
how to get unique values in mysql
sql create alernate key
mysql distinct
sql unique together
distinct values in sql
create unique column in sql server
create table unique constraint
unique values sql
distinct in sql
distinct operator in sql
how to select distinct rows in sql
unique values from a column in sql
sql unique
mysql query distinct
create table distinct sql
sql display unique values
mysql get unique column values
sql server define uniq constant
mssql unique column
sql unique constraint
add a unique constraint in sql server
distinct keyword in sql
select distinct in sql
sql select distinct
SQL Server unique constraint t sql
sqlserver query select dinstint
mysql select distinct
mysql unique values
sql distinct
DISTINCT SQL
