Based on your description, I understand that you want to show SQL server database table in the SharePoint external list.
In the external list, "Last Modified" and "Last Modified by" fields cannot be captured from SQL server database table. These fields are filled in by system.
Based on this Microsoft article, Versioning is not supported in the external list.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.