yes CREATE TABLE "accessmenu" ( "UID" int(11) NOT

is there more the two primary key in a single table?

Question Posted / murugavel

26 Answers
33420 Views
Eforce, Systematix, I also Faced
E-Mail Answers

Answer Posted / murugavel

yes
CREATE TABLE "accessmenu" (
"UID" int(11) NOT NULL DEFAULT '0',
"MID" int(11) NOT NULL DEFAULT '0',
"AlterPermission" tinyint(4) DEFAULT '0',
PRIMARY KEY ("UID","MID")
);

Is This Answer Correct ?

4 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between cte and view?

975

Explain syntax for disabling triggers?

1093

What is transact-sql language?

1135

What is table-valued sub query?

1026

What is nonclustered index with included columns ?

1015

What is row_number()?

1050

What is the recovery model? List the types of recovery model available in sql server?

944

What is the web service used for reporting services?

126

What does null mean?

1052

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1351

Explain full-text indexing?

1042

Explain an incremental backup?

1049

How to drop an existing table with "drop table" statements in ms sql server?

1147

How to copy data from one table to another table?

1051

Explain about unique identifier data type in sql server?

976