Hi Lowell

I found 3 other things which could be interesting for you.

1) The column names in the index and constraint statements should be in squre brackets

for indexes where the...

Hi Lowell

I am using your procedure for an automatic update script (from develpoment --> productive server).

During the test of the update script I found some differences which have lead to...

Hi

I added another small improvment.

The keyword "clustered" or "nonclustered" in the index creation statement.

Without this all indexes are created as nonclustered indexes which is in the most cases correct.

But...

Nice procedure, saves me a lot of work.

Thanks for sharing it.

I have made some small improvement to add the order (asc,desc) of the index columns.

Maybe you want to add...