Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are lock objects?

976


Explain the table, which contain the details of all the name of the programs and forms?

923


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?

2111


What is example class

1280


What are the different types of parameters? How can you distinguish between different kinds of parameters?

948


What are the pooled and cluster tables?

998


How will you find manager of an employee

1293


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?

2184


hi i need detailed information on badi and bapi how can this work in real time senarios plz explain with exp

3642


How can you manipulate the presentation and attributes of interactive lists?

1112


What is database view ? : sap abap data dictionary

994


What are the different types of laws. What are they?

1032


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?

2147


Does the table can have multiple foreign keys?

991


What are the 2 other types of views, which are not allowed in release 3.0?

1070