Create Schema in DB

Transact-SQL
1

Hello Admins
Have a db with version-number in the DB name i.e ABC511
Download new DB frequently with new version name i.e ABC52 etc.
Want to create script do the following:
Create a schema in the DB as below.

USE [ABC511]
GO
CREATE SCHEMA [Name] AUTHORIZATION [User]
GO

But i want the script to be without hardcoded db-name.
Regards Urban

2

Would you like this to be automated and run how often?

How is the database file downloaded? Where is it downloaded to? What extension does it have