# Rule: pattern_rule

## Properties

Property | Value
--- | ---
Name | pattern_rule
ID | 404196490
Schema | dbo
Owner | dbo
Expression | @value LIKE '__-%[0-9]'
Published |
Uses Quoted Identifier |
Uses Database Colation |
Null on Null Input |
MS Shipped |
Modify Date | 10/19/2011 12:36:49 AM
Creation Date | 10/19/2011 12:36:49 AM

## Extended Properties

No extended properties defined.

## Bound Columns

No columns bound to that rule.

## Bound Datatypes

No datatypes bound to that rule

## Objects that depend on [pattern_rule]

- dbo.pattern_rule

## Objects on which [pattern_rule] depends

- dbo.pattern_rule

## SQL

Script
CREATE RULE pattern_rule AS @value LIKE '__-%[0-9]'

#### See also

List of Rules