https://learn.microsoft.com/hu-hu/sql/relational-databases/system-stored-procedures/sp-dropdevice-transact-sql?view=sql-server-ver17
sp_dropdevice (Transact-SQL) - SQL Server | Microsoft Learn
Drops a database device or backup device from SQL Server instance, deleting the entry from master.dbo.sysdevices.
sql serversptransactmicrosoftlearn