I wrote code like
ALTER TABLE [dbo].[Questions]
ADD UNIQUE (Question);
But it shows error like
Column 'Question' in table 'Questions' is of a type that is invalid for use as a key column in an index.
Please help me..
Asked
Active
Viewed 235 times
-2
marc_s
- 732,580
- 175
- 1,330
- 1,459
SURESH MOGUDALA
- 35
- 1
- 12
-
Please add the DDL statement for your Questions table to your question (no pun intended :-) ). – Frank Schmitt May 21 '14 at 06:09
-
the problem is column definition I have given NVARCHAR(MAX) SO it is not altering the table .I solved this thing. – SURESH MOGUDALA May 21 '14 at 06:38
2 Answers
1
ALTER TABLE [dbo].[Questions] ADD constraint q_pk UNIQUE (Question);
vhadalgi
- 7,027
- 6
- 38
- 67
-
I got the solution for my question . column does not contain like nvarchar(MAX). so that it gives error now rectified. thanks. – SURESH MOGUDALA May 21 '14 at 06:32
0
ALTER TABLE [dbo].[Questions] ADD UNIQUE (Question); Column 'Question' in table 'Questions' is of a type that is invalid for use as a key column in an index.
In Question-column of table Questions should not be 'nvarchar(MAX)' but i have
given before table schema question as nvarchar(max) so it gives such error
Questions' is of a type that is invalid for use as a key column in an index.
I have changed to varchar(255). Its working fine. Thanks.
SURESH MOGUDALA
- 35
- 1
- 12