Sign in Get Started

how to set foreign key in sql server

Diego M. 
-- On Create
CREATE TABLE tableName (
    ID INT,
    SomeEntityID INT,
    PRIMARY KEY (ID),
    FOREIGN KEY (SomeEntityID)
        REFERENCES SomeEntityTable(ID)
        ON DELETE CASCADE
);

-- On Alter, if the column already exists but has no FK
ALTER TABLE
  tableName
ADD
  FOREIGN KEY (SomeEntityID) REFERENCES SomeEntityTable(ID) ON DELETE CASCADE;
  
 -- Add FK with a specific name
 -- On Alter, if the column already exists but has no FK
ALTER TABLE
  tableName
ADD CONSTRAINT fk_name
  FOREIGN KEY (SomeEntityID) REFERENCES SomeEntityTable(ID) ON DELETE CASCADE;
View another examples Add Own solution
Log in, to leave a comment

3.8
10
PovilasID 70 points 

                                    CREATE TABLE Orders (
    OrderID int NOT NULL,
    OrderNumber int NOT NULL,
    PersonID int,
    PRIMARY KEY (OrderID),
    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);

3.8 (10 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category SQL
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
how to set up primary key as a foreign key in sql foreign key constraint mysql add foreign key with table create sql sql server alter table add constraint foreign key foreign key sur mysql mysql how to create foreign key mysql foreign key references on t sql add foreign key constraint create table with foreign key constraint sql server mysql foreign key tutorial foreign key myswl foreign key in sql table mysql how to create foreign key in sql server foreign key mysql tutorial how to give foreign key reference in mysql foreign keys mysql syntax for declaring foreign key in mysql how to implement foreign key in sql set fk in sql server mysql foreignkey mysql foreign key can insert before constraint foreign key mysql create foreign key table in mysql how to create sql server query using primary key and foreign key mysql reference foreign key how to create foreign key in mysql foreign key mysql foreign key create table mysql add foreign key mysql alter table add foreign key in dbms mysql create table with foreign key in mysql create table query with foreign key sql server foreign key constraint how to create a foreign key in sql create table sql foreign key how to alter table with a foreign key mysql foreign fey add foreigb key how to add constraint foreign key in sql create table column foreign key apply foreigh key in sql foring key refrences create table with secondary key Add new column to table with foreign key constraint add foreign key in sql add FOREIGN key alter table sql create table with primary key and foreign keys sql reference foreign key foreign key sql code add foreign key to esxitng tab;e foreign sql w3 sql foreign key create table with foreign key mysql sql script to create table with primary key and foreign key foreign key in sql query adding foreign key in mysql foreign key sql example foreign key refference in sql add foreign key to a table in sql foreign key sql server script how to create a foreign key in mssql how to add foreign key in existing table in mysql sql foreign key constaint add a foreign key to an existing table sql how to update a foreign key column in sql sql fk create table constraint foreign key add foreign key ms sql server alter table sql int to fk sql server create table primary key references sql foreign key constraint add constraint foreign key sql server sql server create constraint foreign key create table with foriegn key HOW TO CREATE FORIEGN KEY IN SQL creating a primary key and secondary key in SQL reference sql create foreign key sql server how to set foreign key in sql server alter table mysql foreign key how to foreign key mysql mysql create table with foreign key foreign id for mysql how to declare a foreign key in oracle set foreign key MSSQL FOREIGN KEY create forign jkey syntax add constraint foreign key add foren ket in mysql add table with foreign key sql sql server create foreign key constraint foreign key sql server fk sql query create foreign key how to select foreign key in database how to create primary key and foreign key sql sql create table foreign key foreign key constraint in sql add foreign key constraint to existing column in sql server foreign keys sql server foregn key sql foreign key sql server sql add foreign key sql foreign key syntax how to add foreign key in mysql create a table with foreign key in mysql foreign key in database alter table sql foreign key alter table foreign key foreign key example reference in mysql add foreign key in sql server how to create foreign key in sql define foreign key sql wqhen creating table how to call an foreign key how to add foreign key in sql foeign key sql foreign key consteraints sql alter table with reference add foreign key sql server foreign key constraint sql server how create foregaing kay sql foreing key drop add foreign key constraint to an existing table create foreign key sql make a foreign key in mysql create foreign key in sql sql add foreign key existing table add foreign key foreign key constraint alter table add constraint foreign key sql server add foreign key defining foreign key in sql drop foreign key drop foreign key mysql foreign key in sql server query mysql foreign key example foreign key en mysql sql server foreign key add columns to table with Foreign key sql sql foreign key create table mysql create table foreign key foreign key msql add foreign key to create table mysql foreing key mysql add foreign key sql how to set foreign key in mysql how to insert foreign key in sql foreign keys sql foreign key in mysql sql alter table add foreign key sql set column as foreign key alter table foreign key mysql create foreign key in mysql mysql reference key how to create a foreign key in mysql forign key mysql foreign key sql sql with foreign key how to declare foreign key in sql mysql foreign key sql foreign key how to write a foreign key in sql create table foreign key mysql mysql alter table constraint foreign key alter table add foreign key alter maping of key to foreing key in mysql how to make an existing column a foreign key in mysql adding foreign key options alter table add foreign key mysql set foreign key in mysql add foreign key mysql foreign key command in mysql in table foreign key mysql mysql create foreign key add foreign keys to existing table mysql mysql create foreign key alter table example mysql add foreign key create my sql table with forien key create foreign key mysql alter table add foreign key mysql
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source