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 |
How to Insert multiple rows with a single insert statement?
What is single-user mode?
What is reference section?
What is the maximum size of column in sql server?
what purpose does OPENXML clause have in sql server stored procedure?
What happens if you insert a duplicate key for the primary key column in ms sql server?
How do I get to sql server configuration manager?
what is the maximum size of sql row in mssql?
What is the purpose of forms?
whats new about truncate in sql server 2008?
0 Answers MedSave Healthcare, Serco,
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Why use sub query in sql server and list out types of sub queries?
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)