How to create a Table with a composite primary key with Microsoft.SqlServer.Management.Smo objects?

Question

I am trying to create a table in my C# program with Microsoft.SqlServer.Management.Smo.Table. This table would have 3 columns consisting the PK. However, Microsoft.SqlServer.Management.Smo.Column doesn't seem to allow to specify that. Any ideas? Thank you.

Answer 1

The following example uses a unique key; you may want to try it as a primary:

http://technet.microsoft.com/en-us/library/ms162179(SQL.90).aspx

---

Paul ~~~~ Microsoft MVP (Visual Basic)