You can't drop the parent table in a foreign key relationship, but you can drop the child.

You can't drop a table that has a schema-bound view associated with it.

Here's some tests:

CREATE TABLE parent

(

Id INT PRIMARY Key

)

GO

CREATE TABLE child

(

id INT,

parent_id INT REFERENCES parent(id)

)

GO

-- will not work because it is the parent table

DROP TABLE parent;

GO

-- you can drop the child table

DROP TABLE child;

GO

CREATE TABLE child

(

id INT,

parent_id INT REFERENCES parent(id)

)

GO

CREATE VIEW vw_child

WITH SCHEMABINDING

AS

SELECT id, parent_id FROM dbo.child

GO

-- can't drop the table if there is schema bound view

DROP TABLE child;

Go