SQL - Kodeao

SQL – Foreign Key and its use Database

30 July 202330 July 2023 by Deependra Singh

In this article you will learn about- What is foreign Key? A foreign key can be defined in either a CREATE TABLE statement or an ALTER TABLE statement. Using a CREATE TABLE statement Syntax: The syntax for creating a foreign key using a CREATE TABLE statement is: Example: Parent Table – STOCK Using an ALTER … Read more

SQL – Primary Key and its use in a Database

30 July 202323 July 2023 by Deependra Singh

In this article you will learn about- What is primary Key? A primary key can be defined in either a CREATE TABLE statement or an ALTER TABLE statement. Databases use keys to compare, sort, and store records, and to create relationships between records. Choosing the primary key in a database is one of the most … Read more