How do we specify an ALTERNATE KEY while creating a table?

Define candidate key, alternate key, composite key.

Question Posted / mustafa

Answer Posted / mustafa

Is This Answer Correct ?

15 Yes

30 No

Please Help Members By Posting Answers For Below Questions

What is row_number () and partition by in sql server?

1078

How can you list all the table constraints in a database?

938

How does stuff differ from the replace function?

1010

What do you understand by a view? What does the with check option clause for a view do?

996

application server is slow what may be the problem

2216

What do you do in data exploration

986

How to truncate the log in sql server 2012? : sql server database administration

1280

What is the difference between a primary key and a unique key? Are they the same?

1075

Which are the two editions in which SQL Azure database available?

119

Explain what is the purpose of sql profiler in sql server?

1070

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1019

Does transparent data encryption provide encryption when transmitting data across the network?

1034

Define Business Edition in SQL Azure?

100

What are the default system databases in sql server 2000?

1027

Can we add an identity column to decimal datatype?

999