Answer / vignesh lakshmirajan

ONE COLUMN MAY HAVE N NUMBER OF COLUMNS,.. THERE IS NO RESTRICTION IN THAT.. BUT A TABLE SHOULD CONTAIN ONLY ONE PRIMARY KEY, BUT IT MAY HAVE N NUMBER OF UNIQUE KEYS.

Answer / shashi kishor prasad

In a Table there can have as many as 1024 colums but not
more than that is allowed. There can be only 1 primary key
in a table However you can combine multiple keys together to
act like a primary key that is called composite key.
Composite key is also a primary key, difference is that it
is a combination of no of colums that act as candidate key.

Answer / rehan khan

guys first plz check the question what is exactly asked ok

the numbers of column in a table can range from 1 to 254 and only one primary key in a table .

How can I create a new template for import ? : sql server management studio

1 Answers  

---

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

---

What is the difference between migration and upgradation in sql server?

1 Answers  

---

Can we insert data if clustered index is disabled?

1 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

1 Answers  

---

How to Debug a Stored Procedure?

5 Answers   Allianz,

---

What is model database in sql server?

1 Answers  

---

How does normalization work?

1 Answers  

---

What is check constraint in sql server?

1 Answers  

---

What are the fixed server level roles? : sql server security

1 Answers  

---

What are ddl triggers and types of ddl trigger?

1 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---