Sql server® 2012 t-sql fundamentals

Creating Tables and Defining Data Integrity

This section describes the fundamentals of creating tables and defining data integrity using T-SQL. 

Feel free to run the included code samples in your environment. 

More Info

  If you don’t know yet how to run code against SQL Server, the Appendix will 

help you get started.

As mentioned earlier, DML rather than DDL is the focus of this book. Still, it is important that you 

understand how to create tables and define data integrity. I will not go into the explicit details here, 

but I will provide a brief description of the essentials.

Before you look at the code for creating a table, remember that tables reside within schemas, and 

schemas reside within databases. The examples use the book’s sample database, TSQL2012, and a 

schema called dbo. 

More Info

  See the Appendix for details on creating the sample database.

The examples here use a schema named dbo that is created automatically in every database and is 

also used as the default schema for users who are not explicitly associated with a different schema.

www.it-ebooks.info

---