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
Explain the difference between a pool table and a transparent table?
What is the relationship existing between the various data elements? : abap data dictionary
Explain the difference between open_form and close_form?
How do you work with semi colon se[arated files in BDC ?
What is a data element?
Define infotype ? : abap hr
How will you find manager of an employee
What are the two statements which are required in an abap program to output an icon using a write statement?
Explain the Importance of pa20? : abap hr
What is open sql?
What are the 2 other types of views, which are not allowed in release 3.0?
What is an interactive report?
What are the functions of lock objects?
How to debug rfc function module?
What are critical issues you have faced in your project