saturation
asked on
Drop index, alter column, Create Index
I need to drop indexes to alter some fields. However, I need to rebuild those indexes just as they were before they were dropped. Some of my indexes have more than one field on them. How do I ensure the indexes are re-created the same way they were before dropped?
DROP INDEX table_name.index_name
ALTER table_name ALTER COLUMN field_name nvarchar (x)
CREATE INDEX ????????
DROP INDEX table_name.index_name
ALTER table_name ALTER COLUMN field_name nvarchar (x)
CREATE INDEX ????????
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No. But as indicated you can use SSMS to create the appropriate scripts.
You can see the date time in SSMS (Created date for Index)
ASKER