MSSQL 2005 create table auto increment primary key - MSDN - Microsoft

I got this sql after doing right click>new table. CREATE TABLE ... How can i make email as primary key and the id as auto_increment column?

social.msdn.microsoft.com