Can we create a Table Without a Primary key?
Answer Posted / vivek kikaan
Who says it cannot be created. I just created 1 in MySQL.
mysql> create table DUMMY_TABLE(id INT NOT NULL, first_name VARCHAR(20) default NULL, last_name VARCHAR(20) default NULL, salary INT default NULL);
Query OK, 0 rows affected (0.12 sec)
mysql> desc DUMMY_TABLE;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id | int(11) | NO | | NULL | |
| first_name | varchar(20) | YES | | NULL | |
| last_name | varchar(20) | YES | | NULL | |
| salary | int(11) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql>
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How to combine multiple order in one Delivery ( Step by Step)?
What are the types of indexes in abap?
What are the types of parameters in the function modules?
function modules are also external subroutines. State true or false. : abap modularization
In which time constraint does the infotype records depend on the subtype ? : abap hr
How to find Kernal badi ?
Is it possible to bring select option in module pool screens?
What will exactly the hide statement do?
What are differences between at selection-screen and at selection-screen output?
What is a logical database?
What are the different types joins?
What are Delivery classes? What data will you want to transport during client copy?
Why do we use dynamic where conditions?
How we format the data before writing a statement in the report?
How to set an Enhancement point for a custom report?