forked from docs/doc-exports
Su, Xiaomeng
be9eabe464
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com> Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
23 lines
1.6 KiB
HTML
23 lines
1.6 KiB
HTML
<a name="dli_08_15008"></a><a name="dli_08_15008"></a>
|
|
|
|
<h1 class="topictitle1">CREATE DATABASE</h1>
|
|
<div id="body0000001695823776"><div class="section" id="dli_08_15008__section1139510566557"><h4 class="sectiontitle">Function</h4><p id="dli_08_15008__p76141345565">This statement creates a database using specified table attributes. If a table with the same name already exists in the database, an exception is thrown.</p>
|
|
</div>
|
|
<div class="section" id="dli_08_15008__section042171585510"><h4 class="sectiontitle">Syntax</h4><pre class="screen" id="dli_08_15008__screen25252710559">CREATE DATABASE [IF NOT EXISTS] [catalog_name.]db_name
|
|
[COMMENT database_comment]
|
|
WITH (key1=val1, key2=val2, ...)</pre>
|
|
</div>
|
|
<div class="section" id="dli_08_15008__section5359729165614"><h4 class="sectiontitle">Description</h4><p id="dli_08_15008__p78171420125615"><strong id="dli_08_15008__b2045043719568">IF NOT EXISTS</strong></p>
|
|
<p id="dli_08_15008__p1481722025617">If the database already exists, no operation is performed.</p>
|
|
<p id="dli_08_15008__p16817152019565"><strong id="dli_08_15008__b3941639165611">WITH OPTIONS</strong></p>
|
|
<p id="dli_08_15008__p2019825124119">Database attributes typically store additional information about the database.</p>
|
|
<p id="dli_08_15008__p178181120195617">The key and value of the <strong id="dli_08_15008__b1828316103813">key1=val1</strong> expression are string literals.</p>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dli_08_15005.html">Data Definition Language (DDL)</a></div>
|
|
</div>
|
|
</div>
|
|
|