What happens if we remove primary key from SQL table?

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 9th, 2010

No problem, we use rename operationand we relace the forigen key inti primary key

bikash_tamang

 Profile Answers by bikash_tamang Questions by bikash_tamang

• Jul 10th, 2009

Once the primary key is removed two things will happen:1. The clustered index is also removed which decreases performance and2. The table would then allow duplicate data to be inserted causing data corruption.

Answer Question  Select Best Answer

Display details of employees having same char at the star and end postition of their namelike abishikathis name have last character and first character is same

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Jun 8th, 2011

In Teradata,sel * from employee where substr(name,1,1)=substr(name,length(trim(name)),1)

Miao Lin

 Profile Answers by Miao Lin Questions by Miao Lin

• May 9th, 2011

SELECT * from employee where SUBSTR(EmployeeName, 1,1) = SUBSTR(EmployeeName, -1,1);

Answer Question  Select Best Answer