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 |
|
tishri
Yak Posting Veteran
95 Posts |
 Posted - 2006-04-15 : 06:37:18
|
hey guys i need help on setting up [check contraints] on a [table] to a [view][table A] [views] x int ----------> x int y int  TCC |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-15 : 06:42:15
|
| All the contraint which are applicable on the table are also present on view.. What are you trying to do ??If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
tishri
Yak Posting Veteran
95 Posts |
Posted - 2006-04-15 : 06:58:49
|
| what i mean is i want to relate table with views. it this possible.. i had created a view named [Subscribers View] and i want that view to relate on a table named as [table Accounts]. I found no option in my sql 2000 diagram designer. thanks for the reply TCC |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-15 : 07:06:25
|
| i dont think you can link view to the table..you can link to the table on which the view is createdIf Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
tishri
Yak Posting Veteran
95 Posts |
Posted - 2006-04-15 : 07:10:44
|
| or is this possible ?CREATE TABLE accounts ( account_no int CHECK IN ( SELECT DISTINCT account_no FROM subscribers WHERE [name] is not null), [name] varchar (13) )TCC |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-15 : 07:24:49
|
| Not sure whether you can use sub quries in the Check Contraint.. just try and if not working then you always attach the trigger during the inserting..If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
tishri
Yak Posting Veteran
95 Posts |
Posted - 2006-04-15 : 07:29:07
|
| i am working on a very huge database. using triggers i think may slow the operation. what else can you suggest other than triggers?TCC |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-15 : 08:06:01
|
| I cant think of any other way from Back End.. but how about validating during inserting in front end?If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
|
|
|
check contraints on tables