The topics in this section provide information to help you design effective tables.
Introduces the main tasks in designing a table.
Explains the data types available in SQL Server.These include system-supplied data types, user-defined alias data types, and Microsoft .NET Framework common language runtime (CLR) user-defined types.
Explains the concept of creating system-generated table values that are unique to a table or a computer network.
Explains how to create virtual columns that use values computed from other columns in the same table.
Provides guidelines for designing PRIMARY KEY, FOREIGN KEY, UNIQUE, and CHECK constraints; designing defaults; and specifying nullability in table definitions.