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

Explain the difference between a pool table and a transparent table?

1022


What is the relationship existing between the various data elements? : abap data dictionary

1030


Explain the difference between open_form and close_form?

1012


How do you work with semi colon se[arated files in BDC ?

1947


What is a data element?

944


Define infotype ? : abap hr

1277


How will you find manager of an employee

1338


What are the two statements which are required in an abap program to output an icon using a write statement?

1298


Explain the Importance of pa20? : abap hr

1149


What is open sql?

1219


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

1121


What is an interactive report?

1121


What are the functions of lock objects?

1202


How to debug rfc function module?

1278


What are critical issues you have faced in your project

3362