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 is conversion of data types done between abap/4 & db layer?
What are ranges?
How many types of views are there ?
IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.
Explain what is an rdbms?
How to debug rfc function module?
What are number ranges?
Can multiple abap systems connect to abap database?
What is the difference between a dialog program and a report?
What are the data classes in abap?
What is exception class and test class. How to use it?
Can we create an abap program without using y or z?
What is your approach to find exit and BAdi?
Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?
How to create report in SD open sales order which covers all Organization, delivery status, shipping details and partner function details. plz mention the detail coding Tahnks, Rahul