Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Thursday, March 25, 2021

Generate script to recreate the DDL with data and without data

Hi,

To recreate the DDL please follow below procedure


If you would like to generate the script with data please select Advance in that Advanced Scripting Option please select the type of data to script : Schema and data



on Successful finish of this wizard will open a script window and we can save or share to other instance to regenerate the DDL

Regards


1 comment:

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,