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

Can a rule be bound to any column of any data type?

761


Is it safe to delete log files?

696


Explain what are partitioned views and distributed partitioned views?

728


What is the usage of the sign function?

732


How to use subqueries in the from clause in ms sql server?

856


Can we add an identity column to decimal datatype?

779


Does sql server use java?

770


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

957


When a primary key constraint is included in a table, what other constraints does this imply?

791


Explain intellisense for query editing

783


How to stop log file growing too big?

784


What is efficiency data?

744


How to add a new dsn with the odbc driver for sql server?

764


What is the security principal at the database level that represents your session?

736


Explain what is analysis service repository?

733