SQLDave2015 - Wednesday, March 22, 2017 10:32 AM
You seem to have simply replaced the "CREATE" with "ALTER" in a CREATE TABLE script.
This will not work and will error out as its not valid syntax for ALTER TABLE statement.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/