No announcements
Found 351080 threads
-
0 VotesConfusion 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 | 2294 Views | Created by Bloodofgods - Thursday, September 10, 2015 4:26 AM | Last reply by Soumen Barua - Friday, September 18, 2015 3:07 PM
-
1 Votes
About primary key in the table?
depends on the primary key constraints you have set.Answered | 1 Replies | 3956 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 -
1 Votes
about insert and primary key
Since we have no DDL, we have no idea what the primary key is.Answered | 10 Replies | 1920 Views | Created by bestrongself - Wednesday, March 12, 2014 4:03 AM | Last reply by --CELKO-- - Wednesday, March 12, 2014 2:44 PM -
0 Votes
Primary keys and joining tables
Person.PersonPhone table, I can see three primary keys defined.Answered | 2 Replies | 1016 Views | Created by Ewok177 - Monday, August 24, 2015 1:58 PM | Last reply by Anthony C-UK - Monday, August 24, 2015 2:21 PM -
0 Votes
Primary Key and uniqueidentifier
If you use the identity property on your int primary keys replication will handle this by creating islands of identity key values which will likely not ...Answered | 3 Replies | 7598 Views | Created by Jay Pabs - Thursday, July 29, 2010 8:00 AM | Last reply by Hilary Cotter - Tuesday, August 3, 2010 11:46 AM -
2 Votes
datatable primary key
And this is enforced by a unique constraint which now is the primary key.Answered | 3 Replies | 1896 Views | Created by satuday - Wednesday, August 15, 2012 9:48 PM | Last reply by Sergey Poberezovskiy - Thursday, August 16, 2012 11:08 PM -
4 Votes
Is Primary Key Really needed.
As mentioned, the big difference is that primary keys do not allow nulls.Answered | 7 Replies | 4762 Views | Created by taaSarge - Wednesday, December 19, 2012 7:04 PM | Last reply by Jayanth Kurup - Wednesday, January 2, 2013 1:29 PM -
0 Votes
Virtual Primary Key
And I'd make sure that any table you want to use in LS has an autoincrement integer primary key.Answered | 4 Replies | 3532 Views | Created by RowdyBullGaming - Friday, July 29, 2011 7:31 PM | Last reply by Yann Duran - Monday, August 1, 2011 11:22 AM -
1 Votes
Primary Key Violation
Your identity column is often times the primary key for the table but is not necessarily the same.Answered | 3 Replies | 5044 Views | Created by DBA_KevyKev - Saturday, November 14, 2009 10:33 PM | Last reply by DogTog - Sunday, November 15, 2009 1:19 AM -
2 Votes
Primary Key Already Exists
When during the linked table creation process a primary key could be determined, then Jet/DAO creates the primary key on the linked table itself.Answered | 3 Replies | 1729 Views | Created by IndigoMontoya - Monday, April 6, 2015 4:01 PM | Last reply by Stefan Hoffmann - Monday, April 6, 2015 9:03 PM -
0 Votes
primary key constraints
one and only ONE primary key!Answered | 1 Replies | 5433 Views | Created by goms - Thursday, February 18, 2010 6:56 AM | Last reply by Rajendra Kumbar - Thursday, February 18, 2010 7:05 AM -
0 Votes
Primary keys and column ordering
In practicaly terms, however, SQL Server implements both PRIMARY KEY and UNIQUE constraints as unique indexes.Answered | 2 Replies | 7656 Views | Created by Captain Kernel - Thursday, February 3, 2011 11:38 PM | Last reply by TiborK - Friday, February 4, 2011 7:43 AM -
1 Votes
Primary, Foreign Key
> For A, it has 1 primary key and B has a foreign key which maps to table > A primary key.Answered | 2 Replies | 1398 Views | Created by Wen Hao Mui - Thursday, June 7, 2012 3:00 PM | Last reply by darnold924 - Thursday, June 7, 2012 3:36 PM -
0 Votes
Primary key with ID
> I always thought that PRIMARY KEYs had to be unique?Answered | 8 Replies | 5320 Views | Created by HMote - Monday, July 4, 2011 4:16 PM | Last reply by --CELKO-- - Sunday, July 10, 2011 6:12 PM -
0 Votes
Create a Primary Key
I think it is just as simple as creating them afterwards: CREATE TABLE my_table (my_pk_col int NOT NULL ...Answered | 3 Replies | 3761 Views | Created by janets20 - Friday, May 28, 2010 1:56 PM | Last reply by Gert-Jan Strik - Saturday, May 29, 2010 11:29 PM -
0 Votes
Multiple Primary key
Thats fine that we cannot create multiple primary key...Answered | 5 Replies | 4312 Views | Created by psingla - Tuesday, July 20, 2010 11:39 AM | Last reply by Kent Waldrop - Tuesday, July 20, 2010 2:19 PM -
1 Votes
Composite Primary Key
create table t(idx int not null, code varchar(30) not null,cname varchar(30)) alter table t add constraint pk_t primary key (idx,code)Answered | 2 Replies | 12533 Views | Created by KIRAN KUAMR - Friday, March 4, 2011 6:49 AM | Last reply by Grant Guan - Friday, March 4, 2011 7:05 AM -
0 Votes
Edit primary key
How custom property will help me to edit primary key from application??Answered | 5 Replies | 2318 Views | Created by nicolasInter - Wednesday, May 9, 2012 1:06 AM | Last reply by Sunetra Moholkar - Thursday, March 23, 2017 7:09 AM -
0 Votes
Droppin primary key constraint
I recommend you to use T-SQL statement as follows (sql server 2005 or later): /* -- table for test */ CREATE TABLE test1 ( a int primary ...Answered | 4 Replies | 5393 Views | Created by DB Team - Wednesday, November 18, 2009 6:41 AM | Last reply by DB Team - Wednesday, November 18, 2009 9:09 AM -
2 Votes
Cluster index and primary key
By default SQL Server creates a clustered index when you create a PRIMARY KEY.Answered | 5 Replies | 9771 Views | Created by subu999 - Saturday, October 30, 2010 5:53 AM | Last reply by Uri Dimant - Monday, November 1, 2010 7:43 AM
No announcements
