List of INDEX with create and DROP script should not include any constrains P/F

Question

List of INDEX with create and DROP script should not include any constrains P/F

DBA.k

Ten Centuries

Points: 1113
More actions
December 10, 2019 at 2:49 pm

#3706514

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..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

rvsc48 SSCertifiable Points: 7702 More actions · Answer 1

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.

Jeff Moden SSC Guru Points: 1004419 More actions · Answer 2

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)