Foreign key

Laravel foreign key

Schema::table('posts', function (Blueprint $table) {
    $table->unsignedBigInteger('user_id');

    $table->foreign('user_id')->references('id')->on('users');
});
OR
Schema::table('posts', function (Blueprint $table) {
    $table->foreignId('user_id')->constrained();
});

Drop foreign key

ALTER TABLE table_name
DROP CONSTRAINT fk_name;

Source: techonthenet.com

Foreign key

USE Organization
CREATE TABLE Employee_Office
(
Id INT PRIMARY KEY IDENTITY(1,1),
Emp_Id int FOREIGN KEY REFERENCES Employee(Id),
Office_Id int FOREIGN KEY REFERENCES Office(Id)
)

Source: codingsight.com

Foreign key

CREATE TABLE Employee(
    EmployeeID int NOT NULL,
    LastName varchar(50) NOT NULL,
    FirstName varchar(20) NOT NULL,
    Age int,
    DeptNo int,
    PRIMARY KEY (EmployeeID),
    FOREIGN KEY (DeptNo) REFERENCES Department(DeptNo)
);

Source: computerscienceai.com

Foreign key

USE Organization
CREATE TABLE Employee
(
Id INT PRIMARY KEY IDENTITY(1,1),
Name VARCHAR (50) NOT NULL,
Age INT,
Gender VARCHAR (50),
Dep_Id int FOREIGN KEY REFERENCES Department(Id),
Insur_Id int FOREIGN KEY REFERENCES Insurance(Id)
)

Source: codingsight.com

Foreign key

ALTER TABLE your_table ADD FOREIGN KEY (your_column) REFERENCES other_table(other_column);

Source: stackoverflow.com

Similar codes

1 vote192 views1 answer
How to get the date diff on once field in sql server
SQL
13 votes144 views2 answers
Oracle all source
SQL
52 votes839 views6 answers
Rename column sql
SQL
0 vote193 views1 answer
What is between keyword used for
SQL
5 votes225 views2 answers
Mysql dump mysql db cli
SQL
0 vote194 views1 answer
Get role postgres
SQL
0 vote181 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote214 views1 answer
Get created time of database psql 8
SQL
0 vote204 views1 answer
Power bi union columns
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL