Here’s how you go about getting a listing of all the indexes for a specific table: declare @src sysname set @src = ‘boobs’ select object_name(object_id),* from sys.indexes where object_name(object_id) = @src
Here’s how you go about getting a listing of all the indexes for a specific table: declare @src sysname set @src = ‘boobs’ select object_name(object_id),* from sys.indexes where object_name(object_id) = @src