Hi,
I did it in Ms SQL Server, running a "Drop and Create To .." I just dropped the table and recreated the same table, but this time with the fields in the right order.
This is the sample I wrote:
USE [SDE Ms SQL Server Database]
GO
ALTER TABLE [APP].[MyFCToReorder] DROP CONSTRAINT [g2789_ck]
GO
/****** Object: Table [APP].[MyFCToReorder] Script Date: 6/10/2019 1:44:37 PM ******/
DROP TABLE [APP].[MyFCToReorder]
GO
/****** Object: Table [APP].[MyFCToReorder] Script Date: 6/10/2019 1:44:37 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [APP].[MyFCToReorder](
[OBJECTID] [int] NOT NULL,
[FCID] [nvarchar](20) NULL,
[FieldReordered] [nvarchar](30) NULL,
…..
Hope it helps.