How can I see the properties of Stored Procedure after Reverse Engineering from a database?
When you reverse engineer a model that contains stored procedures, all the stored procedures move to the model-level.
Take the following Stored Procedure as an example:
-----------------------------
Create procedure [st].[DropGeometryColumn]
@schema_name [nvarchar](4000),
@table_name [nvarchar](4000),
@column_name [nvarchar](4000)
with execute as caller
as
external name [MsSqlSpatialLibrary].[StoredProcedure].[DropGeometryColumn]
go
----------------------------
After Reverse Engineering a Stored Procedure into erwin dm, go to the Model Explorer and expand Stored Procedure
Right-click the procedure and go to Properties to see more detail
Additionally, this is universal for all database and not just SQL server as shown in the screenshots. This does not limit only to seeing stored procedures after reverse engineering. It can be applied to all objects that is in the model whether created or by reverse engineering. All these are stored in the Model Explorer.
