Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000?

Answer Posted / kirubaharan

Unable to create index 'PK'.
Cannot define PRIMARY KEY constraint on Computed column in
table.
Could not create constraint. See previous errors.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the restrictions while creating batches in sql server?

587


Explain how does the report manager work in ssrs?

501


How to execute a sql statement using odbc_exec()?

574


what are the different stages of Report Processing?

97


What is a natural primary key?

527






What is trigger explain with program?

540


What is the difference between deallocate cursor and close cursor?

727


Mention the different types of triggers?

553


Explain iaas, paas and saas?

74


What is multi-statement table-value user-defined function?

542


What is a ddl statement?

513


Is it true, that there is no difference between a rule and a check constraint?

528


How can a user-defined datatype be created?

547


explain different types of constraints? : Sql server database administration

518


What do we have to check in database testing?

585