Interested to Buy Any Domain ? << Click Here >> for more details...
One table how may column and Primary key
- 3 Answers
- 5295 Views
- I also Faced
- E-Mail Answers
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)
