December 10, 2019 at 2:49 pm
Hello Sir..
Please help me the script..
From entire database i want List of INDEX with CREATE and DROP INDEX script, But in this should not include any constrains like primary keys and Foreign keys. Please help any one have the script like this?
Thank you..
December 10, 2019 at 5:17 pm
Have you seen these generate drop and create scripts? https://www.mssqltips.com/sqlservertip/3441/script-out-all-sql-server-indexes-in-a-database-using-tsql/
I just tested them and I do not see constraints in the results, which is what you are requesting I believe.
December 10, 2019 at 5:35 pm
What on Earth would you actually use this for? If you ever do it to an actual database, you will cause a huge explosion in the MDF files as clustered indexes are rebuilt as heaps.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply