Home Alternative to rules for User-Defined Data Types
Reply: 0

Alternative to rules for User-Defined Data Types

Anil Bakirci
1#
Anil Bakirci Published in 2017-11-13 14:53:56Z

Since the rules are deprecated, what is the correct syntax to use constraints with User-defined types (I don't mean user-defined table types)?

CREATE TYPE MyType
FROM NCHAR(10) NOT NULL    
CONSTRAINT CHECK(MyType IN ('haha', 'hoho'))

This is not working...

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.297905 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO