I created ECT for a SQL server Table using SPD 2013..

In DB table  ID column is primary key descending column.

In SQL Server when I run the command "Select * from <Table>" I do see the records in descending order of ID column value, AS EXPECTED....

In my External list 'List View' this is not replicated. I do not want to create a custom view for this 'List view' to show records with ID descending values...

Which step am I mistaking?

Hi,

I have done a test in my SharePoint 2013 and I can reproduce your issue.

ID column is primary key descending column In DB table.

After I create external list  form the DB table using SPD 2013, it will ascending by id in my external list.

Per my test, I came to a conclusion that when we create a list in SharePoint (contains external list), it is by default ordered by the first column descending.

For your issue, you don't need to create a new view, just modify the default view, then set order by id descending.

Hope that helps.

Best Regards

Lisa Chen