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.