How to change order in fields in sde FC

[JoseSanchez]

Hello everyone,

Is there a way to change move a field in a FC to be listed in the 3rd position instead of the 10th position?

Thanks

[RobertBorchert]

Easily, no there is not and this has been a point of contention for quite a few years.

There are ways to do it with Python as I have seen posted.

However, for me the easiest way is to make the feature class in a personal Geodatabase.  Unloaded is fine

Open the database in MS Access.  Reorder the fields in Access.

Bring the new world order into your SDE. 

[JoseSanchez]

Thanks Robert,

When moving  a FC to a PGDB, some attributes change, for example the decimal part of a number, and also it adds additional shape fields.

[RobertBorchert]

How are you doing it?

Make the feature class in the personal.  Import the attributes from the SDE database.  Reorder and make the feature class in SDE.  then use data loader to load direct from SDE to SDE

[JoseSanchez]

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.

[leomonterol]

Hi Jose,

You can use the X-Ray add-in for ArcCatalog. This add-in provides the functionality to reorder fields in a Feature Class.

Regards,

Leo