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

6 votes169 views1 answer
What is where clause in sql
SQL
1 vote163 views1 answer
Postgres grant read only access to database
SQL
-1 vote118 views3 answers
Ubuntu install mssql
SQL
1 vote175 views1 answer
Name of today sql
SQL
0 vote197 views2 answers
Drop tables from local table database postgres
SQL
0 vote169 views1 answer
Get number of tables in database sql
SQL
0 vote211 views1 answer
Sql select without column name
SQL
0 vote128 views1 answer
Mysql collation for all languages
SQL
0 vote168 views1 answer
Sql counter column
SQL
0 vote170 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL