What do you mean by foreign key?

SQL | Foreign Key A foreign key is a key used to link two tables.  A Primary key of a table is used as a foreign key for the other table. Primary key is a…

What is a view in SQL?

SQL | View View in SQL is a kind of virtual table. It does not physical exists in our database but have rows and column as there we have in real database table. we can…

What is the difference between primary key and unique constraints?

SQL | Difference between primary key and unique constraints There is only one primary key in a table. It creates the cluster index automatically and it cannot have NULL value where as there can be…