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 table control cn be generated using bdc? : abap bdc
What is modularization and its benefits? : abap modularization
When the get cursor command used in interactive lists?
Select query optimisation
please any one can tell me How to validate the data in Table maintinance generator?how can u validate the table field values if u r entering the data into fields .it shows record is wrong?wher we can done validation in table maitenance generator before getting the data as out ?
What are the different types of internal table?
What are the functional modules used in sequence in bdc? : abap bdc
What is the difference between a pool table and a transparent table?
How many types of views are there ?
What is open sql?
What is interactive reporting?
What is the basic difference internal tables and database tables? : abap data dictionary
What is macro? : abap hr
Persistent class
How is time management and payroll is integrated? : sap abap hr