Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mohamed Faisal
Yak Posting Veteran
51 Posts |
 Posted - 2012-09-24 : 01:54:32
|
| Hi All,below is my code:CREATE TABLE ClientTable(clientID char(5) NOT NULL,clientName Char(30) NOT NULL,clientAddress char(50) NOT NULL,clientContact Numeric(8) NOT NULL,CONSTRAINT ClientTablePK PRIMARY KEY(clientID),CHECK(clientID like '[A-Z][0-9][0-9][0-9][A-Z]'),CHECK (clientContact like '[6][0-9][0-9][0-9][0-9][0-9][0-9][0-9]' ORclientContact like'[0-9][0-9][0-9][0-9][0-9][0-9][0-9]' ORclientContact like'[9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'));How do I disallow delete and update to ClientID. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-24 : 03:03:03
|
| create an instead of update trigger or make it primary key if its unique identifier------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
delete and update disallowed