Search
 
SCRIPT & CODE EXAMPLE
 

SQL

SQL Server Altering Column to be Unique

alter table location_key drop constraint pinky;
alter table your_table add constraint pinky unique(yourcolumn);
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql compare timestamp in minutes 
Sql :: postgres how to index a column 
Sql :: mysql remove auto increment 
Sql :: mysql multiple order by 
Sql :: get week day from date in sql 
Sql :: sql character index 
Sql :: how to set a column as unique in sql server 
Sql :: convert polygon to text in mysql 
Sql :: mysql count by month 
Sql :: mysql identified by syntax error 
Sql :: add comma after 3 digits select sql 
Sql :: sql change data type 
Sql :: update sqlite 
Sql :: create temporary table sql 
Sql :: oracle all_dependencies 
Sql :: unique key in ms sql server 
Sql :: how to select random rows from table 
Sql :: sql server list database 
Sql :: athena create table 
Sql :: get initial in sql 
Sql :: sql update multiple rows 
Sql :: oracle session statistics 
Sql :: show details of table postgres 
Sql :: Using GROUP BY in MySQL Join Table 
Sql :: import data from csv to sql server 
Sql :: sql select where 
Sql :: functions with parameters SQL 
Sql :: oracle list days between two dates 
Sql :: alter column to not null with default value sql server 
Sql :: mysql command 
ADD CONTENT
Topic
Content
Source link
Name
7+4 =