SQL Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'cascade'

Question

I'm fairly new to SQL so any help with this would be greatly appreciated. I cant spot the syntax error!

-- Creación de la tabla Departamento
DROP TABLE IF EXISTS Departamento CASCADE;

[`DROP TABLE` syntax](https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-table-transact-sql?view=sql-server-ver15), please read — Charlieface, Jul 16 '21 at 17:29
The error is giving you a hint here. `CASCADE` shouldn't be there. — Larnu, Jul 16 '21 at 17:31

score 0 · Answer 1 · answered Jul 16 '21 at 17:28

0

DROP TABLE IF EXISTS Departamento

CASCADE is about something different

answered Jul 16 '21 at 17:28

Sergey

1 Answers1