This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.
This script selects all primary keys for all tables in a database and creates the ALTER script to reapply them. It seems I created this in 2015 to allow primary keys to be exported from one…
Continue Reading azurecurve’s Article on their blog
SQL Scripts for Microsoft Dynamics GP: Select All Primary Keys and Generate ALTER Script
This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP. This script selects all primary keys for all tables in a database and creates the ALTER script to reapply them.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
Dyn365GP2023.01.27SQL Scripts for Microsoft Dynamics GP: PO Receipt History View- Dyn365GP2023.01.27SQL View to Return the Accounting Period Starting and Ending Dates in Microsoft Dynamics 365 Business Central
- Dyn365GP2023.01.26SQL Scripts for Microsoft Dynamics GP: SQL Trogger on PO invoice Insert to Change GL posted Date
- Dyn365GP2023.01.26Inactive OneDrive Account Cannot be Removed
