Toad World® Forums

Index - Reverse Engineer


When reverse engineering the script for an index, Toad places a “USE master” after the "USE " of the real db. The “use master” statement should not be generated. In most installations, it would be surprising in user db objects were (attempted) to be created in master.

See example:

/****** Object: INDEX [AK1_xxx] - Script Date: 1/18/2011 3:13:26 PM ******/

use [COMMON]

use master
create nonclustered index AK1_xxx on COMMON.dbo.yyy (col_1, col_2)


Hello Elmo_731,

Sorry for the inconvenience, I created and fixed CR 81,585 for this issue. The extra “USE master” statement will no longer be there in the next beta.



Hello elmo_731,

Have you tried the latest beta? Please, let me know if this is working for you now.