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