{"id":59,"date":"2016-05-18T00:16:28","date_gmt":"2016-05-18T07:16:28","guid":{"rendered":"https:\/\/database.guide\/?p=59"},"modified":"2020-02-14T16:35:18","modified_gmt":"2020-02-14T23:35:18","slug":"how-to-create-a-database-in-sql-server","status":"publish","type":"post","link":"https:\/\/database.guide\/how-to-create-a-database-in-sql-server\/","title":{"rendered":"How to Create a Database in SQL Server"},"content":{"rendered":"

To create a database<\/a> in SQL Server<\/a> using the GUI:<\/p>\n

    \n
  1. From the Object Explorer, right click on\u00a0Databases<\/kbd>\u00a0and select New database...<\/kbd><\/li>\n
  2. Name the database, adjust settings if\u00a0required, then click OK<\/kbd><\/li>\n<\/ol>\n

    Once you’ve created the database, you can create tables<\/a> and other database objects. You can also modify any database properties as required.<\/p>\n

    <\/p>\n

    Below are\u00a0screenshots for the above steps.<\/p>\n

    The Object Explorer<\/h2>\n

    From the Object Explorer, right click on\u00a0Databases<\/kbd>\u00a0and select New database...<\/kbd>:<\/p>\n

    \"Screenshot<\/a>
    Right-clicking on an option in the Object Explorer usually brings up a contextual menu that enables you to choose an option.<\/figcaption><\/figure>\n

    Name the Database<\/h2>\n

    Name the database, adjust settings as required, then click OK<\/kbd>:<\/p>\n

    \"Screenshot<\/a>
    The “New Database” dialog in SQL Server 2014. Here you provide a name for the database and adjust other settings if required.<\/figcaption><\/figure>\n

    The database will now appear in the Object Explorer\u00a0under Databases<\/samp>.<\/p>\n

    Database Properties<\/h2>\n

    You can adjust the database properties by right-clicking on the database in the Object Explorer:<\/p>\n

    \"Screenshot<\/a>
    Right-clicking on the database in the Object Explorer opens a contextual menu that you can select properties and other options from.<\/figcaption><\/figure>\n

    This brings up the Database Properties dialog:<\/p>\n

    \"Screenshot<\/a>
    The Database Properties dialog box allows you to configure the properties of your database. You can find a property by selecting the applicable page from the left menu.<\/figcaption><\/figure>\n

    The Model Database<\/h2>\n

    When you create your database, it uses the model<\/strong> database as a template.<\/p>\n

    The\u00a0model<\/strong> database is created when you install SQL Server. You can see the database in the list of databases in the Object Explorer\u00a0even before you create your first database.<\/p>\n

    If you create new databases regularly, and immediately find yourself having to modify them with the same changes each time, you can modify the model<\/strong> database to incorporate those changes.\u00a0You will no longer need to modify every database you create with the same changes.<\/p>\n

    For example, you could set permissions, add objects such as tables, functions, or stored procedures<\/a>, and more.<\/p>\n

    Restrictions of the Model Database<\/h3>\n

    However, there are some tasks that can’t be performed on the model<\/strong> database. As of SQL Server 2016 these are<\/a>:<\/p>\n