ForeignKey and ForeignKeyColumn objects in SMO
Wow, these two objects have the potential to really be confusing. These objects can be used within SMO to create foreign keys unfortunately, these two objects have the potential to create a lot of confusion in someone's mind. Thankfully, there is a pretty good example include with Sql Server December CTP. Check out the url: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/smo9/html/104c9ec1-7aca-453c-88ce-07a0a232c738.htm for the info.