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
What are lock objects?
Explain the table, which contain the details of all the name of the programs and forms?
in bdc session method. if u run the record in fore ground manually i have a 7 records but at the time of record processing first record produces the error how can u process records manually in fore ground please tell me any one knows?
What is example class
What are the different types of parameters? How can you distinguish between different kinds of parameters?
What are the pooled and cluster tables?
How will you find manager of an employee
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?
hi i need detailed information on badi and bapi how can this work in real time senarios plz explain with exp
How can you manipulate the presentation and attributes of interactive lists?
What is database view ? : sap abap data dictionary
What are the different types of laws. What are they?
i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?
Does the table can have multiple foreign keys?
What are the 2 other types of views, which are not allowed in release 3.0?