SQL Server Tutorials

This SQL server tutorial explains how to specify a default value for a column in SQL Server Table Designer.

Developers can specify a default value, for each column in their table, which will be entered in the column if the end user leaves it blank. When developers do not assign a default value and the user leaves [...]

This SQL Server tutorial explains how to create a primary key in SQL Server Table Designer.

Developers define a primary key to to enforce uniqueness for values entered in specified columns that do not allow nulls. A table can have only one primary key. Primary keys is used to relate the table in which is defined to [...]

This SQL server tutorial explains how to change relationship properties in SQL Server Table Designer.

When developers create a relationship, referential integrity between tables is enforced by default. An enforced relationship ensures each value entered in a foreign key column matches an existing value in the related primary key column. Developers

can change the conditions under which referential [...]

This SQL server tutorial explains how to create indexes in SQL Server Table Designer.

Developers use indexes to speed access to data in a database table. They create an index by selecting one or more columns in a table that they want to be able to search on. They can use the index as soon as they [...]

This SQL Server tutorial explains how to create a unique constraint in SQL Server Table Designer.

Developers create a unique constraint to ensure no duplicate values are entered in specific columns that do not participate in a primary key. While both a unique constraint and a primary key enforce uniqueness, developers should attach a unique constraint instead [...]

This SQL server tutorial explains how to delete columns from a table in SQL Server Table Designer.

Developers can use SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 Table Designer to delete a column. When developers delete a column, once they save the changes, the column and all the data it contains [...]

This SQL server tutorial explains how to specify a computed column in SQL Server Table Designer.

Developers can specify an expression for a computed column in Table Designer. A computed column expression can use data from other columns to calculate a value for the column to which it belongs. When developers working with SQL Server “Denali”, MS [...]

This SQL Server tutorial explains how to modify a primary key in SQL Server Table Designer.

Developers modify a primary key when he/she wants to change the column order, index name, clustered option, or fill factor. In this case Developers follow the next steps:

1. Open the Table Designer for the [...]

This SQL server tutorial explains how to create relationships between tables in SQL Server Table Designer.

Developers create a relationship between two tables when they want to associate rows of one table with rows of another. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to create relationships [...]

This SQL server tutorial explains how to create unique indexes in SQL Server Table Designer.

Developers, in Microsoft SQL Server, create a unique index on a unique column (such as product id) or on a set of columns that together uniquely identify each record (such as vendor + product).When Developers create or modify a unique index, they [...]