No announcements
Found 351074 threads
-
1 VotesPrimary Key
Hi, You can not create primary key on empno as the values of empno have duplicates(empno 10 and empno 30) in a primary key column.Answered | 7 Replies | 2700 Views | Created by pnreddy - Tuesday, February 14, 2012 12:17 PM | Last reply by jaisean - Tuesday, February 14, 2012 1:12 PM
-
0 Votes
Primary key
As Kalman wrote, Primary Key is a default Unique Key.Answered | 10 Replies | 3509 Views | Created by swethakrishna - Thursday, August 1, 2013 10:48 AM | Last reply by --CELKO-- - Thursday, August 1, 2013 4:56 PM -
3 Votes
PRIMARY KEY
In such case we can define Primary key on (FirstName + LastName+Class) Not a good idea.Answered | 6 Replies | 1600 Views | Created by I4QR1A - Thursday, November 27, 2014 8:12 PM | Last reply by DileepReddyAchhala - Friday, November 28, 2014 11:21 AM -
1 Votes
Primary keys
PRIMARY KEY is never NULL.Answered | 4 Replies | 1157 Views | Created by FenixRising - Monday, March 31, 2014 7:35 PM | Last reply by Kalman Toth - Tuesday, April 1, 2014 8:12 PM -
0 Votes
Primary Key and Foreign Key
For example, suppose you have a Products table with primary key ProductID and an Orders table with primary key OrderID and each line item on the ...Answered | 4 Replies | 1216 Views | Created by Ronald Rex - Sunday, September 9, 2018 12:21 AM | Last reply by Ronald Rex - Sunday, September 9, 2018 7:02 PM -
0 Votes
Primary key
Create table table with CREATE TABLE, define the primary key.Answered | 12 Replies | 1003 Views | Created by simonxy - Wednesday, February 24, 2016 5:33 PM | Last reply by Sam Zha - Thursday, February 25, 2016 3:48 AM -
0 Votes
Primary keys
Do you mean by "relationships in a DB-schema" a) relation, thus two tables having the primary key over the same set of attributes ...Answered | 4 Replies | 523 Views | Created by loinike - Friday, July 15, 2016 7:42 AM | Last reply by Stefan Hoffmann - Friday, July 15, 2016 8:49 AM -
1 Votes
Primary key and Foreign Key
See this illustration create table t ( id int identity(1,1) not null primary key, val varchar(100) ) create table t2 ( id int not ...Answered | 4 Replies | 1531 Views | Created by smtaqi - Saturday, August 30, 2014 8:08 AM | Last reply by Visakh16 - Saturday, August 30, 2014 6:59 PM -
3 Votes
Composite Primary key and Foreign key
I would say FIPS is a primary key although I haven't checked.Answered | 18 Replies | 61035 Views | Created by mahima - Friday, February 8, 2008 3:51 PM | Last reply by Kalman Toth - Sunday, April 10, 2011 8:52 PM -
2 Votes
Difference Primary Key & Unique key?
4)A table can have only one primary key.Answered | 3 Replies | 6282 Views | Created by GurunGuns - Saturday, June 26, 2010 10:02 AM | Last reply by Mohammad Nizamuddin - Saturday, June 26, 2010 11:35 AM -
3 Votes
Primary Key Design Practices
What is the rationale behind (almost) never making a Natural Key the Primary Key?Answered | 18 Replies | 7876 Views | Created by Mercury529 - Friday, November 23, 2012 7:22 PM | Last reply by Naomi N - Monday, November 26, 2012 12:28 AM -
1 Votes
2 Primary Keys
Here is the simplified declarative syntax: create table Test_table( Col1 int identity(1,1) PRIMARY KEY, col2 int NOT NULL ...Answered | 10 Replies | 1528 Views | Created by Debra has a question - Friday, March 14, 2014 4:50 PM | Last reply by davidbaxterbrowne - Saturday, March 15, 2014 12:31 AM -
0 Votes
Primary key error
In Table A, i have two fields together as Primary Key.Answered | 8 Replies | 4712 Views | Created by NSG12 - Tuesday, March 30, 2010 3:54 PM | Last reply by Kalman Toth - Sunday, April 4, 2010 12:30 PM -
0 Votes
Table primary key and Replication
For transactional replication, all tables which needs to be published need to have a primary key.Answered | 2 Replies | 5765 Views | Created by LOSTCAUSE - Wednesday, June 22, 2011 2:05 PM | Last reply by Ashwin Menon - Thursday, June 23, 2011 3:00 AM -
1 Votes
Two Primary key for table???
tHE BOLD line shows that it has two primary key The bold line shows that you have a primary key composed by two columns.Answered | 2 Replies | 4666 Views | Created by Incredible15 - Sunday, September 12, 2010 4:44 PM | Last reply by Hunchback - Sunday, September 12, 2010 5:06 PM -
2 Votes
primary foreign key referencing
This means that a primary key can be a primary and a foreign key at the same time in the same table?Answered | 9 Replies | 9769 Views | Created by N.Afache - Friday, October 21, 2011 11:51 AM | Last reply by J Alverson - Sunday, October 30, 2011 7:32 AM -
2 Votes
Using symbols in primary key
We think you need to improve the concept of Primary key What is a key, and why is one of them a primary key?Answered | 2 Replies | 1849 Views | Created by ogzgl - Saturday, July 25, 2015 8:35 AM | Last reply by Ahsan Kabir - Monday, August 3, 2015 4:02 AM -
0 Votes
Confusion on Natural Key Primary, vs Surrogate Key Primary
Isn't it true tho that a primary key is the main key on your table that all other indexes run off of?Answered | 9 Replies | 2364 Views | Created by Bloodofgods - Thursday, September 10, 2015 4:26 AM | Last reply by Soumen Barua - Friday, September 18, 2015 3:07 PM -
0 Votes
Primary Key update
Check if there is an update in PRIMARY KEY column 2.Answered | 9 Replies | 8574 Views | Created by Varde - Friday, October 1, 2010 7:42 AM | Last reply by Varde - Thursday, October 7, 2010 9:20 AM -
1 Votes
About primary key in the table?
depends on the primary key constraints you have set.Answered | 1 Replies | 4045 Views | Created by Mitkram - Saturday, October 24, 2009 6:45 AM | Last reply by Jeff - www.SRSoft.us - Saturday, October 24, 2009 1:56 PM - Items 1 to 20 of 351074 Next ›
No announcements
