title: "Lesson 1: Creating Database Objects | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "t-sql" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "article" applies_to:
- "SQL Server 2016" ms.assetid: 9fb8656b-0e4e-4ada-b404-4db4d3eea995 caps.latest.revision: 20 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "On Demand" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-all-md] This lesson shows you how to create a database, create a table in the database, and then access and change the data in the table. Because this lesson is an introduction to using [!INCLUDEtsql], it does not use or describe the many options that are available for these statements.
[!INCLUDEtsql] statements can be written and submitted to the [!INCLUDEssDE] in the following ways:
-
By using [!INCLUDEssManStudioFull]. This tutorial assumes that you are using [!INCLUDEssManStudio], but you can also use [!INCLUDEssManStudio] Express, which is available as a free download from the Microsoft Download Center.
-
By using the sqlcmd utility.
-
By connecting from an application that you create.
The code executes on the [!INCLUDEssDE] in the same way and with the same permissions, regardless of how you submit the code statements.
To run [!INCLUDEtsql] statements in [!INCLUDEssManStudio], open [!INCLUDEssManStudio] and connect to an instance of the [!INCLUDEssDEnoversion].
This lesson contains the following topics: