Home Forums SQL Server 2008 T-SQL (SS2K8) Constraint syntax RE: Constraint syntax
ScottPletcher
SSC Guru
Points: 100923
More actions
January 16, 2015 at 3:06 pm
#1770913
ALTER TABLE dbo.person_test2
ADD CONSTRAINT CK_ext
CHECK ( Pext LIKE REPLICATE('[0-9]', LEN(Pext)) )
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.