USE AdventureWorks2012
DECLARE @tags nvarchar(max);
DECLARE @name nvarchar(max);  
DECLARE @sql  nvarchar(max);
DECLARE @namefull nvarchar(max); 
  
DECLARE my_cursor CURSOR
    FOR 
SELECT distinct
sys.tables.name
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED') 
inner join 
sys.tables on sys.dm_db_index_physical_stats.object_id= sys.tables.object_id
WHERE avg_fragmentation_in_percent > 15.0 AND index_id > 0;
OPEN my_cursor
FETCH NEXT FROM my_cursor INTO @name;
WHILE @@FETCH_STATUS=0
  BEGIN
  DBCC DBREINDEX  
  SET @namefull = '[dbo].['+@name+']'
  set @sql = 'USE AdventureWorks2012
ALTER index all on '+@namefull+' REBUILD'
  EXEC (@sql)
                FETCH NEXT FROM my_cursor INTO @name;
  END
CLOSE my_cursor
DEALLOCATE my_cursor