hi

I think probably you mean the sequence in which the script will be executed .

and hence you are concerned about

ALTER TABLE [dbo].[UserInfo] WITH CHECK ADD CONSTRAINT [FK_UserInfo_Country] FOREIGN KEY([CountryID])

REFERENCES [dbo].[Country] ([CountryID])

when i have not as yet created the Country table.

If that is your concern, I have just generated this script from two table , one by one to just show you.

Correct me if i am wrong

Thank you so much for all your time and effort. So i have now decided to go ahead with this relationship. and yes i have many more such relations in UserInfo with other tables and i will put non clustered indexes on all.

By i means i beleive its a good way to go in terms of Data Integrity and Performance.

What is your final word

Zubair