There are tables in our environment for example a,b,c,d,e,f,g,h,i
We are running
ALTER INDEX ALL ON [dbo].[a] REBUILD WITH (ONLINE = ON);
Manually copy paste on the ssms one by one , Once the index rebuild on table a finishes then we run on table b and when b finished we run c like that,
Can i write a loop where we run the index rebuild within a loop one by one table rebuild index.