What's the equivalent of "DECLARE..." in Databricks SQL ?

[wyzer]

Hello everyone,

I'm new in Databricks SQL, and I'm comming from SQL Server.

I would like to know what's the equivalent of :

DECLARE @P_Name varchar(50) = 'BackOffice'

It's for use it like this :

CREATE DATABASE @P_Name

Thanks.

[Amit_352107]

Hi @Salah K.​ 

you can go through this code block

%python

P_Name = 'BackOffice'

spark.sql(f""" create database {P_name} """)