Close Database Connections From T-SQL

In my recent project, I was required to drop a database while there where probably some open connections.

I googled it and came across this.

So the following is the command I use.

ALTER DATABASE DATABASE_NAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DROP DATABASE DATABASE_NAME
GO