CODEWITHSUNDEEP
foreign-keysazure-sql-databasecreate-table
Paulo Henrique
Paulo Henrique

Reputation: 499

Create table without checking foreign key on unexisting table

I'm adapting a really big query (MySQL to SQL) that creates lots of tables and relationships. The problem is that it always check if a table exists prior to adding a foreign key referencing to that table.

So I have to reorder the queries to avoid this problem, and my question is if there's a instruction that can turn that check off, so it'll create the tables and add references without stopping the query with every error it encounters.

I'm working with SQL in an Azure DB.

Thank you.

Upvotes: 0

Views: 227

Answers (1)

Lukasz Szozda
Lukasz Szozda

Reputation: 175706

Easiest way is to create all tables first and then add constraints using ALTER TABLE.

For example:

CREATE TABLE a(id INT PRIMARY KEY IDENTITY(1,1), b_id INT, c CHAR(10));
CREATE TABLE b(id INT PRIMARY KEY IDENTITY(1,1), z INT);

ALTER TABLE a ADD CONSTRAINT FK_a_b_id_b FOREIGN KEY (b_id) REFERENCES b(id);

Rextester Demo

Upvotes: 3

Related Questions