How can I see the properties of Stored Procedure after Reverse Engineering from a database? (4262896)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How can I see the properties of Stored Procedure after Reverse Engineering from a database?
Description

How can I see the properties of Stored Procedure after Reverse Engineering from a database?
Resolution

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.