Schema structures and stored procedures

Legacy Contributor

Has anyone developed a schema(s) or methodology of naming conventions for stored procedures in Visual?

Find more posts tagged with

Comments

Legacy Contributor

Can you define or explain "Stored procedures"? Do you mean Workflows, or Macros, or something else?

Legacy Contributor

On the SQL server side we are using stored procedures more and more for our reporting services for Visual. I saw an article where someone mentioned using Schemas to organize stored procedures and I was trying to see if there was anyone in the Visual community who has a standardized naming convention. usp_ is about all that I've seen to differentiate them from sp_ which is for the database itself.

Role Based Security Webinar-20200310 1503-1.mp4

Chris Chandler

Use something that is defined by your company name. For example, any object we create is named MTM_. After that, standard naming convention applies for the object type.

ztrue

Yup, never use sp_ as it can cause issues with the system.

Ours are _
e.g. ROYAL_VENDOR_REVIEW, ROYAL_SUPPLY_CHAIN_REVIEW_BY_PART

Copyright © 2025 Infor. All rights reserved.