How to Specify Foriegn Key Relationships in SQL Server 2008

Foriegn Key in SQL Server 2008 - Use the Relationships option

Specify the relationship between the columns

Add new Relationship name and save when prompted

Unable to change Identity Specification in SQL Server 2008

Unable to change Identity Specification in SQL Server 2008

How to make Server Explorer visible in Visual Studio

Server Explorer not visible in Visual Studio

Your pending changes require the following tables to be dropped and re-created

Remove the checkbox 'Prevent saving changes'

How to create auto-increment column in SQL Server

How to Set Increment value in SQL Server

Set Column properties - goto Identity Specification, set (Is Identity) to True (Yes)



SQL Server Identity Specification



How to specify Default value for a column in SQL Server

SQL Server Default Column Values

Here is a way to specify default values in Sql Server Management Studio for a column