Breaking News: Grepper is joining You.com. Read the official announcement!

sql foriegn key

Add Answer

Michael Hazut answered on February 24, 2020 Popularity 9/10 Helpfulness 2/10

answer sql foriegn key

related sql foreign key

related SQL foreign key

related foreign key sql

sql foriegn key

Comment

ALTER TABLE Table_Name
ADD column_name Data_Type,
CONSTRAINT FK_Name FOREIGN KEY(column_name) 
   REFERENCES PK_Table_Name(PK_Column_Name);

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: key sql

Link to this answer
Share Copy Link

Contributed on Aug 08 2022

Michael Hazut

0 Answers Avg Quality 2/10

Closely Related Answers

sql foreign key

Comment

# A foreign key is essentially a reference to a primary
# key in another table.

# A Simple table of Users, 
CREATE TABLE users(
	userId INT NOT NULL,
  	username VARCHAR(64) NOT NULL,
  	passwd VARCHAR(32) NOT NULL,
  	PRIMARY KEY(userId);
);
# Lets add a LEGIT user!
INSERT INTO users VALUES(1000,"Terry","Teabagface$2");

# We will create an order table that holds a reference
# to an order made by our Terry
CREATE TABLE orders(
	orderId INT NOT NULL,
  	orderDescription VARCHAR(255),
  	ordererId INT NOT NULL,
  	PRIMARY KEY(orderId),
  	FOREIGN KEY (ordererId) REFERENCES users(userId)
);
# Now we can add an order from Terry
INSERT INTO orders VALUES(0001,"Goat p0rn Weekly",1000);

# Want to know more about the plight of Goats?
# See the link below

Popularity 10/10 Helpfulness 4/10 Language sql

Source: www.riverfronttimes.com

Tags: key

Link to this answer
Share Copy Link

Contributed on Feb 24 2020

Kaotik

0 Answers Avg Quality 2/10

sql foreign key

Comment

create table Jobs(
job_id number not null,
job_title varchar(30),
min_salary number,
max_salary number
);
create table job_history(
employee_id number not null,
start_date date,
end_date date,
job_id number not null,
department_id number
);
alter table jobs add constraint pk_jobs primary key(job_id);
alter table job_history add constraint fk_job foreign key(job_id) references jobs(job_id);

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: key

Link to this answer
Share Copy Link

Contributed on Sep 20 2021

Fierce Ferret

0 Answers Avg Quality 2/10

SQL foreign key

Comment

# A foreign key is essentially a reference to a primary
# key in another table.

# A Simple table of Users,
CREATE TABLE users(
    id INT NOT NULL AUTO_INCREMENT,
  	username VARCHAR(255) NOT NULL,
  	email VARCHAR(255) NOT NULL,
  	PRIMARY KEY(id)
);
# Lets add a LEGIT user!
INSERT INTO users VALUES(2,"Sharon","sharon@gmail.com");

# We will create an order table that holds a reference
# to an order made by our Terry
CREATE TABLE notes(
    id INT NOT NULL AUTO_INCREMENT,
  	body text,
  	user_id INT NOT NULL,
  	PRIMARY KEY(id),
  	FOREIGN KEY (user_id) REFERENCES users(id)
);
# Now we can add an order from Terry
INSERT INTO notes VALUES(4,"Update my php storm to version 22.3",2);

# Want to know more about the plight of Goats?
# See the link below

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: key

Link to this answer
Share Copy Link

Contributed on Dec 07 2022

Alex Otieno

0 Answers Avg Quality 2/10

foreign key sql

Comment

 A foreign key is an attribute of a relation (subordinate/dependent)
that points to the primary key of another relation (main/master)
FK is used to create a many-to-one (one-to-many) relationship.

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: key

Link to this answer
Share Copy Link

Contributed on Mar 11 2022

coder

0 Answers Avg Quality 2/10

sql foriegn key

Contents

More Related Answers

sql foriegn key

Closely Related Answers

sql foreign key

sql foreign key

SQL foreign key

foreign key sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.