Microsoft SQL Server Management Studio Rename failed for User 'dbo'. (Microsoft.SqlServer.Smo) code example

Example: sql drop with dependencies

DROP TABLE tableName CASCADE; 
-- Table can also be schema or whatever else.