{"id":3673,"date":"2022-01-03T08:39:39","date_gmt":"2022-01-03T08:39:39","guid":{"rendered":"https:\/\/erpconsultors.com\/?p=3673"},"modified":"2022-01-03T08:39:42","modified_gmt":"2022-01-03T08:39:42","slug":"create-database-via-query-in-sql-server","status":"publish","type":"post","link":"https:\/\/erpconsultors.com\/create-database-via-query-in-sql-server\/","title":{"rendered":"Create Database via query in SQL Server"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Create Database via query in SQL Server:<\/h2>\n\n\n\n<p>(1) \u201cCREATE DATABASE\u201d command is used to create a new database in SQL Server.<\/p>\n\n\n\n<p>(2) <strong>Syntax:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table class=\"has-background\" style=\"background-color:#e7f5fe\"><tbody><tr><td>Create Database NameOfDataBase;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>(3) Let&#8217;s create a database via query. Select the database in the SQL server and click on the \u201cNew Query\u201d button as shown.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"318\" data-attachment-id=\"2577\" data-permalink=\"https:\/\/erpconsultors.com\/click-for-new-query-in-sql\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/click-for-new-query-in-sql.png?fit=609%2C318&amp;ssl=1\" data-orig-size=\"609,318\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"click for new query in sql\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/click-for-new-query-in-sql.png?fit=300%2C157&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/click-for-new-query-in-sql.png?fit=609%2C318&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/click-for-new-query-in-sql.png?resize=609%2C318&#038;ssl=1\" alt=\"click for new query in sql\" class=\"wp-image-2577\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/click-for-new-query-in-sql.png?w=609&amp;ssl=1 609w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/click-for-new-query-in-sql.png?resize=300%2C157&amp;ssl=1 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<p>(4) After that new query editor open as shown.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"341\" data-attachment-id=\"2330\" data-permalink=\"https:\/\/erpconsultors.com\/new-query-editor-open-in-sql\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-query-editor-open-in-sql.png?fit=559%2C341&amp;ssl=1\" data-orig-size=\"559,341\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"new query editor open in sql\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-query-editor-open-in-sql.png?fit=300%2C183&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-query-editor-open-in-sql.png?fit=559%2C341&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-query-editor-open-in-sql.png?resize=559%2C341&#038;ssl=1\" alt=\"new query editor open in sql\" class=\"wp-image-2330\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-query-editor-open-in-sql.png?w=559&amp;ssl=1 559w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2021\/12\/new-query-editor-open-in-sql.png?resize=300%2C183&amp;ssl=1 300w\" sizes=\"(max-width: 559px) 100vw, 559px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<p>(5) After doing the above steps, write a query in the editor and press F5 (for executing query) as shown.<\/p>\n\n\n\n<ul><li>Database Created in system defined path automatically.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"427\" data-attachment-id=\"3687\" data-permalink=\"https:\/\/erpconsultors.com\/database-created-in-system-by-default-path-in-sql\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/Database-created-in-system-by-default-path-in-sql.png?fit=577%2C427&amp;ssl=1\" data-orig-size=\"577,427\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Database created in system by default path in sql\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/Database-created-in-system-by-default-path-in-sql.png?fit=300%2C222&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/Database-created-in-system-by-default-path-in-sql.png?fit=577%2C427&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/Database-created-in-system-by-default-path-in-sql.png?resize=577%2C427&#038;ssl=1\" alt=\"Database created in system by default path in sql\" class=\"wp-image-3687\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/Database-created-in-system-by-default-path-in-sql.png?w=577&amp;ssl=1 577w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/Database-created-in-system-by-default-path-in-sql.png?resize=300%2C222&amp;ssl=1 300w\" sizes=\"(max-width: 577px) 100vw, 577px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<ul><li>Database Created in predefined path. Note: in predefined path, before executing the query, please give access to SQl Server to create database, otherwise it will give Access denied error.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"443\" data-attachment-id=\"3690\" data-permalink=\"https:\/\/erpconsultors.com\/database-created-in-predefined-path-in-sql\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-predefined-path-in-sql.png?fit=642%2C443&amp;ssl=1\" data-orig-size=\"642,443\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"database created in predefined path in sql\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-predefined-path-in-sql.png?fit=300%2C207&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-predefined-path-in-sql.png?fit=642%2C443&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-predefined-path-in-sql.png?resize=642%2C443&#038;ssl=1\" alt=\"database created in predefined path in sql\" class=\"wp-image-3690\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-predefined-path-in-sql.png?w=642&amp;ssl=1 642w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-predefined-path-in-sql.png?resize=300%2C207&amp;ssl=1 300w\" sizes=\"(max-width: 642px) 100vw, 642px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<p class=\"has-text-align-center\"><strong>Source Code:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table class=\"has-background\" style=\"background-color:#e7f5fe\"><tbody><tr><td>&#8211;\/\/ Create in define folder<br>CREATE DATABASE MyFirstDBWithDefinePath<br>on (Name = MyFirstDBWithDefinePath_dat,<br>FileName = &#8216;C:\\Users\\Amit\\Desktop\\Amit\\MyFirstDBWithDefinePath.mdf&#8217;)<br>LOG on (Name = MyFirstDBWithDefinePath_log,<br>FileName = &#8216;C:\\Users\\Amit\\Desktop\\Amit\\MyFirstDBWithDefinePath.ldf&#8217;);<br>&#8211;\/\/ Create in define folder<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>(5) After doing the above activity. Refresh or re-login the SQL Server and check the result, as shown.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"456\" height=\"490\" data-attachment-id=\"3694\" data-permalink=\"https:\/\/erpconsultors.com\/database-created-in-sql\/\" data-orig-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-sql.png?fit=456%2C490&amp;ssl=1\" data-orig-size=\"456,490\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"database created in sql\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-sql.png?fit=279%2C300&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-sql.png?fit=456%2C490&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-sql.png?resize=456%2C490&#038;ssl=1\" alt=\"database created in sql\" class=\"wp-image-3694\" title=\"\" srcset=\"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-sql.png?w=456&amp;ssl=1 456w, https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/database-created-in-sql.png?resize=279%2C300&amp;ssl=1 279w\" sizes=\"(max-width: 456px) 100vw, 456px\" data-recalc-dims=\"1\" \/><\/figure><\/div>\n\n\n\n<hr class=\"wp-block-separator aligncenter is-style-wide\"\/>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-background\" style=\"background-color:#e7f5fe\"><tbody><tr><td><a aria-label=\"Use of INNER JOIN in SQL Server (opens in a new tab)\" href=\"https:\/\/erpconsultors.com\/use-of-inner-join-in-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\" class=\"rank-math-link\"><span class=\"has-inline-color has-black-color\">Use of INNER JOIN in SQL Server<\/span><\/a><br><a aria-label=\"Types of JOINS Statement in SQL Server (opens in a new tab)\" href=\"https:\/\/erpconsultors.com\/types-of-joins-statement-in-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\" class=\"rank-math-link\"><span class=\"has-inline-color has-black-color\">Types of JOINS Statement in SQL Server<\/span><\/a><br><a aria-label=\"How to Take BACKUP from SQL Database (opens in a new tab)\" href=\"https:\/\/erpconsultors.com\/how-to-take-backup-from-sql-database\/\" target=\"_blank\" rel=\"noreferrer noopener\" class=\"rank-math-link\"><span class=\"has-inline-color has-black-color\">How to Take BACKUP from SQL Database<\/span><\/a><br><a rel=\"noreferrer noopener\" class=\"rank-math-link\" href=\"https:\/\/erpconsultors.com\/use-of-repeat-until-in-dynamics-365\/\" target=\"_blank\"><span class=\"has-inline-color has-black-color\">Use of REPEAT-UNTIL in Dynamics 365<\/span><\/a><br><a rel=\"noreferrer noopener\" class=\"rank-math-link\" href=\"https:\/\/docs.microsoft.com\/en-us\/dynamics365\/business-central\/finance-general-ledger\" target=\"_blank\"><span class=\"has-inline-color has-black-color\">Understanding the General Ledger and the COA<\/span><\/a><span class=\"has-inline-color has-black-color\">\u2013 Microsoft<\/span><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create Database via query in SQL Server: (1) \u201cCREATE DATABASE\u201d command is used to create a new database in SQL Server. (2) Syntax: Create Database NameOfDataBase; (3) Let&#8217;s create a database via query. Select the database in the SQL server and click on the \u201cNew Query\u201d button as shown. (4) After that new query editor open as shown. (5) After doing the above steps, write a query in the editor and press F5 (for executing query) as shown. Database Created in system defined path automatically. Database Created in predefined path. Note: in predefined path, before executing the query, please give <\/p>\n","protected":false},"author":1,"featured_media":3675,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[48],"tags":[406,405,404],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/erpconsultors.com\/wp-content\/uploads\/2022\/01\/Create-Database-via-query-in-SQL-Server.jpg?fit=350%2C270&ssl=1","_links":{"self":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/3673"}],"collection":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/comments?post=3673"}],"version-history":[{"count":0,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/posts\/3673\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media\/3675"}],"wp:attachment":[{"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/media?parent=3673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/categories?post=3673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpconsultors.com\/wp-json\/wp\/v2\/tags?post=3673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}