MS-SQL - create table with foreign key
/SQL/MS-SQL - create table with foreign key.sql
CREATE TABLE import_info_residence(
-- [pr_id] [numeric](18, 0) IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[lh_id] [numeric](18, 0) NOT NULL
, CONSTRAINT [pk_import_info_residence] PRIMARY KEY CLUSTERED
(
[lh_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
-- FOREIGN KEY :
ALTER TABLE import_info_residence
ADD CONSTRAINT [fk_lieu_hebergement] FOREIGN KEY([lh_id])
REFERENCES [dbo].[lieu_hebergement]([lh_id])
GO