September 5, 2006 at 7:16 am
Hi,
I am trying to create a FK on a column that references another column that is not the same length. We are trying to generate diagrams for customers to be able to create reports. These keys are not going into a production database, but a database without any data that will be used to generate diagrams.
Here is the example
table_1(user_nm varchar(16))
table_2(log_number int, user varchar(25))
I am trying to create a FK on Table 2 that references the user_nm column in table 1, but it is failing with the following error:
Server: Msg 1753, Level 16, State 1, Line 4
Column 'dbo.table_1.user_nm' is not the same length as referencing column 'table_2.user' in foreign key 'FK_table2_user'.
I understand the problem, but does anybody know how to create this relationship other than modifying the length in Table_2?
Thank you,
J. Arpide
September 5, 2006 at 8:00 am
Alter table 1 to make the length 25.
Not sure why you want them to be different. Especially with varchar, just put the smaller one at the length of the larger one.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 5, 2006 at 8:00 am
If you can't alter one of the columns, then you have to enforce it with a trigger.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply