I appreciate in advance your patience, bit of a novice here.

I am building a table set in one stored procedure. I want to define a constraint check at the top of the procedure, and use it inside the different CREATE TABLE loops, or, in other words, I only want to define a phone number constraint once. I do not want to have to cut/past/rename it each time etc.. None of the documentation I have access to shows syntax to do this.

Is it possible? If so, what is the syntax??