>>>The blog link I gave you does 'ALTER TABLE' script to drop / add constraints.
>>>
>>>Alternatively, you should be able to do it with the PowerShell script. You may want to google on 'PowerShell foreign constraints script'
>>
>>I found this page (url below) that shows how to create all FK constraints. I just tested it on a test database and it work well. This is a keeper. I looked at the reference to PowerShell but don't understand it. Even though most people comment that it is easier to use than scripting in SQL Server. Something for me to read at another date.
>>
>>
http://social.technet.microsoft.com/wiki/contents/articles/2958.script-to-create-all-foreign-keys-en-us.aspx>
>Both PowerShell scripts are really great. I ran them and got the scripts.
I don't doubt that; I just need to read more and understand. It is not rush for me right now to use the latest and the greatest tool. I just need to get this customer working (this is my big beta test with SQL Server).
Thanks.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
