<div>
<a href="https://www.sqlshack.com/overview-of-create-database-statement-in-azure-sql-server/" rel="ugc">Check this out.</a>
</div>


Check this out. [https://www.sqlshack.com/overview-of-create-database-statement-in-azure-sql-server/]

<div>
@Marcus, that does not answer the BTU question
</div>


@Marcus, that does not answer the BTU question

<div>
<blockquote>
@Marcus, that does not answer the BTU question
</blockquote>
<br />
<br />
Here is a link to the full help document from Microsoft as far as the Cli is concerned. Surely the poster will find his answer there.<br />
<br />
<a href="https://docs.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest#az-sql-db-create" rel="ugc">az sql db create</a><br />
<br />
Also what is 5BTU supposed to represent (is this a pricing model?)
</div>


> @Marcus, that does not answer the BTU question



Here is a link to the full help document from Microsoft as far as the Cli is concerned. Surely the poster will find his answer there.

az sql db create [https://docs.microsoft.com/en-us/cli/azure/sql/db?view=azure-cli-latest#az-sql-db-create]

Also what is 5BTU supposed to represent (is this a pricing model?)

<div>
You can use the CLI to create a database and choose to have a 100MB size and 5btu. I am asking how to write the script portion for size of 100mb and 5btu. &nbsp;here is what I have so far for the script.<br />
<br />

<pre><code id="code-20-42958793-1">az slq db create --name myserver -g user-jlkljkjjllj -n mydb --edition basic  ---max-size ??  btu??</code></pre>
</div>


You can use the CLI to create a database and choose to have a 100MB size and 5btu. I am asking how to write the script portion for size of 100mb and 5btu.  here is what I have so far for the script.



az slq db create --name myserver -g user-jlkljkjjllj -n mydb --edition basic  ---max-size ??  btu??

<div>
<div class="content wysiwyg-content">
When creating a sql db with cli, how do add 5btu? &nbsp;I have this so far:<br />
<br />
az sql db create --name chr1db --server chris11ql --edition Basic --max-size 100MB (5BTU??)<br />
<br />
Let me clarify, I am looking for what is the <b>--service-object</b>. &nbsp;II cannot find the script for all service levels Specifically, I am looking for Basic. I know Standard is S0.
</div>
</div>


When creating a sql db with cli, how do add 5btu?  I have this so far:

az sql db create --name chr1db --server chris11ql --edition Basic --max-size 100MB (5BTU??)

Let me clarify, I am looking for what is the --service-object.  II cannot find the script for all service levels Specifically, I am looking for Basic. I know Standard is S0.

Azure Cli script db create?

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.