One table how may column and Primary key
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 12 Yes | 3 No |
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.
| Is This Answer Correct ? | 8 Yes | 1 No |
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 .
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the parts of a function?
Explain the difference between function and stored procedure?
What is ACID Property of Transaction?
what is a mixed extent? : Sql server administration
How to override dml statements with triggers?
How can we delete a table in sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
which backup strategy you are following at ur company
What are the 7 disadvantages to a manual system?
What is difference between inner join and join?
What are the types of subquery?
Explain about nested stored procedure?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)