SQL automation doesn’t have a great story in Azure at the moment. You could create a BACPAC file from a local copy of the database and import it - but that can take a long time.
Alternatively you could keep your schema in source code with a SQL Server project and build it into a DACPAC in your pipeline. Then you can use a tool like SqlPackage (part of SQL Server) to generate a deployment script (like this example).