[dba-SQLServer]Roles and Rules etc.

1. So does that mean, forget about them and use check constraints
exclusively?
2. Can a check constraint apply to multiple columns? Or is that by
definition a failure to go to BCNF?

A.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
Djabarov, Robert
Sent: Tuesday, August 19, 2003 11:36 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Roles and Rules etc.


Rule doesn't have anything to do with roles and permissions.  It's
similar however to CHECK constraint.
BOL:
"Rules, a backward compatibility feature, perform some of the same
functions as check constraints. CHECK constraints, created using the
CHECK keyword of ALTER or CREATE TABLE, are the preferred, standard way
to restrict the values in a column (multiple constraints can be defined
on one or multiple columns)."

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003