Chapter 12. Creating and Managing Tables in SQL Server

by Paul Jensen

IN THIS CHAPTER

  • Datatypes

  • Numeric Datatypes

  • Datatype Synonyms

  • User-Defined Datatypes

  • Creating Tables

  • Creating Tables Using T-SQL

  • Creating Tables Using Table Designer

  • Viewing Table Properties and Data in Enterprise Manager

  • Limitations on Table Size and Dimensions

  • Dropping Tables

  • Temporary Tables

The table is the basic structure upon which the relational database is built. A table is a set of columns, having defined properties, used to store data. The stored data is represented as rows in the table. These rows are used to represent an entity (an employee, for example), that has a number of attributes (last name, salary) associated with it. These attributes are stored in the table's columns. ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial