Technically, yes. You can create a Rule and then bind the rule to different columns.

However, constraints are the perferred mechanism and it does require that you specify them each time.

-Mike

>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??