Interested to Buy Any Domain ? << Click Here >> for more details...
One table how may column and Primary key
- 3 Answers
- 5364 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 differences between clustered and non-clustered index?
What is primary key, unique key, and foreign key?
One table how may column and Primary key
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to loop through result set objects using mssql_fetch_array()?
What is multilevel indexing?
How do I know if localdb is running?
What happens if null values are involved in string operations?
How retrieve field names from the table in SQL through JAVA code?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Explain log shipping and mention its advantages.
-
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)
