What is difference between foreign key and unique key?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    Answered by anusha kadimi

    Foreign key is a field in the table that is Primary key in another table Unique Constraint may have a NULL value. Each table can have more than one Unique Constraint. By default, Unique key is a unique non-clustered index. Unique Constraint can not be related with another table's as a Foreign Key

Related Questions

Please Login or Register to leave a response.

Related Questions

Mssql Interview Questions

What is MSSQL?

MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..

Mssql Interview Questions

What is SQL server agent and what are the two modes of authentication in SQL Server?

SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..

Mssql Interview Questions

What is SQL Profiler?

It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..