Databases

To view all unique constraints in a database in MSSQL, use below auery. select TC.Constraint_Name, CC.Column_Name, CC.TABLE_NAME from information_schema.table_constraints TC inner join information_schema.constraint_column_usage CC on TC.Constraint_Name = CC.Constraint_Name where TC.constraint_type = 'Unique' order by TC.Constraint_Name;

InnoDB has row-level locking, MyISAM can only do full table-level locking. InnoDB has better crash recovery. MyISAM has  FULLTEXT  search indexes, InnoDB did not until MySQL 5.6. InnoDB implements transactions, foreign keys and relationship constraints, MyISAM does not.

Just curious to know best databases in 2017. From the serverwatch, I got some information. Oracle Microsoft SQL Server IBM DB2 SAP Sybase ASE PostgreSQL MariaDB Enterprise MySQL Teradata Informix Ingres

MSSQL To create a unique constraint on a table, use below query. alter table <tableName> add constraint <constraintName> unique(<column>); MySQL  To create a unique constraint on a table, use below query. alter table `<tableName>` add unique (column(s));