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 is singleton pattern in OOPS?
– Programming using BAPI : Create Debit Memo Request (DMR) with reference to Sales Order and update the delivery number and PO number in the newly created DMR. Send the spool of the report by E-mail if the E-mail option is enabled. Selection Screen Required: Sales Org Delivery type Sales document type Optional: Planned Goods movement date Option to choose E-Mail E-mail Address Output device Output Output should display both successful and unsuccessful creation of DMR with the following fields, Success/Error (S/E) Sales Document number Delivery number New Debit memo request number Error message Tables TVAK, TVCPA, VBAK, LIKP, LIPS
Define external layer? : abap data dictionary
What are the differences between the table and the structure in the data dictionary in the sap abap?
What happens Update command is used without where clause ?
What is the difference between retroactive accounting period, earliest retroactive accounting period? : sap abap hr
Hi, I have a requirement for locking the fax field in user master records. As you know user can edit the details using the System>profile>own data (SU3), it is causing some security threat to our model. What i want is users should not be able to change the fax field under communications when they get into su3.I have heard of user Exist functionality but don't know how to implement it. Can you suggest something, it will be greatly appreciated.
What is dialog module?
Define abap/4 layer?
THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM
Differentiate between abap memory and sap memory?
On which even we can validate the input fields in module progams?
How to Solve a Particular Ticket in Realtime ?
Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
What is the difference between data elements and domains? : abap data dictionary