To disable Transparent Data Encryption (TDE) on SQL Server database, below code can be used.
USE MASTER
GO
ALTER DATABASE DatabaseName
SET ENCRYPTION OFF
GO
USE DatabaseName GO
DROP DATABASE ENCRYPTION KEY
GO