sql create table with references not primary key

Quaint Quail answered on October 19, 2021 Popularity 1/10 Helpfulness 1/10

answer sql create table with references not primary key

sql create table with references not primary key

Comment

CREATE TABLE Users(
  address varchar(100),
  phone_number varchar(20),
  userid serial,
  constraint pk primary key (address, phone_number ),
  constraint userid_unq unique (userid)
);

create table Stores(
  storeid int primary key,
  ownerID integer,
  constraint b_fk foreign key (ownerID)
    references Users(userid)
);

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: create-table primary-key sql

Link to this answer
Share Copy Link

Contributed on Oct 19 2021

Quaint Quail

0 Answers Avg Quality 2/10

sql create table with references not primary key

Contents

More Related Answers

sql create table with references not primary key

Grepper

Documentation

Social

Legal

Contact

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