How to Create a Forward Engineer Script with User Defined Extended Properties for SQL Server

Description:

How to Create a Forward Engineer Script with User Defined Extended Properties for SQL Server? For example:

EXEC sys.sp_addextendedproperty @name=N'WITRSDataObjectId', 
@value=N'6923972' , 
...
GO

Solution:

Here are the steps to generate script for User Defined Extended Properties for tables and columns in SQL Server:

1. Go to table properties and assign an owner / schema to table (this is required
2. In table properties, select UDP Tab and create a new UDP.  Make sure the box "Is Database Property" is checked (selected) when creating the UDP, whether Table or Column level.
3. Create the Extended Property UDP.
4. When generating a script, please make sure select the box "User Defined Properties" under FE/Other Options window.
5. Review the results.