Stored Procedures Support

Hello
As part of designing a database i would like to be able to design stored procedures as part of the design. Thanks