Hi

I have been working a bit more on this problem. Using the following call I managed to create and export a list of all tables with their foreign keys:

sp_msforeachtable...

Thanks Andy,

Your solution helped me in the right direction. The code below I use now to copy tables is more generic, hope others will be able to use it...

Hi

Thanks for the reply. I have seen this SP and I am still stuck using this SP to loop through all the table's foreign key names. The statement to alter the...