Sql

-- Add a Unique constraint and deifine the constraint name
ALTER TABLE TABLENAME
ADD	CONSTRAINT UQ_tblPerson_Email UNIQUE(COLUMN_NAME)

PREVIOUS	NEXT

Code Example
Sql :: delete a record from a table sqlite3
Sql :: show columns in sql
Sql :: postgres list all stored procedures query
Sql :: mysql limit offset
Sql :: SQL: merging multiple row data in string
Sql :: clone table structure mysql
Sql :: sql in sublime
Sql :: postgresql drop table
Sql :: mysql get all tables row count
Sql :: create table sqlite
Sql :: drop unique key constraint in sql server
Sql :: insert value in identity
Sql :: insert data in pgsql
Sql :: mysql columns values as comma separated string
Sql :: input in mysql
Sql :: sql where first letter
Sql :: get comma separated values in sql server
Sql :: mysql set value as null
Sql :: get duplicate records in sql
Sql :: ubuntu connect to mssql database
Sql :: create user sql server
Sql :: postgresql get difference between two dates
Sql :: use concat in group_concat
Sql :: change auto increment mysql
Sql :: Get the Db column names from a SqlDataReader
Sql :: error code 1451 sql
Sql :: spring where to put the data sql
Sql :: mysql get last insert id
Sql :: oracle sql select all days between two dates except weekends
Sql :: how to combine first and last nae into one columb sql