Advertisement

Creating Tables and Other Objects

  • Rob Walters
  • Grant Fritchey

Abstract

In this chapter, you will learn how to create various objects within the SQL Server database. Primarily, we’ll focus on creating tables and objects, such as indexes and constraints, that are closely related to tables. To get the most out of this chapter, you should follow along using SQL Server Management Studio and the instance of SQL Server you installed in Chapter 2. It is important to note that there are multiple ways to create object in SQL Server. Two of the most common ways are by issuing Transact SQL (T-SQL) statements directly to SQL Server using a tool such as SSMS or SQLCMD and by using the management dialogs in a management tool like SSMS.

Keywords

Unique Constraint Execution Plan Structure Query Language Check Constraint Table Designer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Rob Walters, Grant Fritchey 2012

Authors and Affiliations

  • Rob Walters
  • Grant Fritchey

There are no affiliations available

Personalised recommendations