Mine

DECLARE Tables CURSOR FORSELECT DISTINCT  QUOTENAME(TABLE_CATALOG) + '.' +     QUOTENAME(TABLE_SCHEMA) + '.' +    QUOTENAME(TABLE_NAME)FROM INFORMATION_SCHEMA.TABLESWHERE TABLE_TYPE = 'BASE TABLE'OPEN TablesDECLARE @table varchar(128)FETCH NEXT FROM Tables INTO @tableWHILE @@FETCH_STATUS = 0BEGIN  PRINT 'Reindexing table ' + ISNULL(@table, '<NULL>')  IF @table IS NOT NULL  BEGIN    DELETE FROM @table  END  FETCH NEXT FROM Tables INTO @tableENDCLOSE TablesDEALLOCATE Tables