Topic profile page for Primary Key.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Primary Key.
Topic "Primary key" was discussed 15,314 times on 485 sites in last 3 months
Started 2 days, 6 hours ago (2009-11-23 21:37:00)
by BP
Hi , I heard in a debate sometimes it's better to create a unique index on a column and using it instaed of using primary key index in oracle.I couldn't understand what the reason propely. Can anyone please help me in thsi topic if it is a valid one . Thanks in advance
Started 2 days, 21 hours ago (2009-11-23 07:19:00)
by manojkiean
Hi friends, I am using vs 2008 linq in mY web Applications. My requirement is specified below.. Example Employee Code : EMP1001 (PRIMARY KEY) Employee Name : MANOJ KIEAN Address : K K Nagar City : Chennai these are columns in Database... i want to update Employee Code then to (Employee Code == MAN1001) like this using LINQ Entity Model.. these is my DataContext oDC.srpEmployees....
Started 3 days, 1 hour ago (2009-11-23 03:13:00)
by Faser
I'm using cfdbinfo to retrieve the table fields and identify the primary key. cfdbinfo fails against SQL Server 2008 when the table is in a custom schema. The same thing using PostgreSQL works. Any advice? Eg: CREATE SCHEMA fasertest GO CREATE TABLE fasertest.test( pk int identity, name varchar(20) PRIMARY KEY(pk) )
Started 3 days, 18 hours ago (2009-11-22 09:45:00)
by jominsons
Hi I have a table which has an auto incrementing primary key column which for some reason is out of order. I can sort it in phpmyadmin but it keeps falling out of order and I'm not sure why. Any thoughts anyone ?
Started 3 days, 18 hours ago (2009-11-22 09:34:00)
by Mohamed Houri
Dears, I have a situation that I want to expose here I have a parent table and a child one as follow for example parent (par_id, total_time, remain_time) child(chi_id, par_id, time) ===> par_id is a foreign key to the parent id primary key. chi_id is the primary key of the child table The business of those two tables is that we can have as ...
Started 3 days, 23 hours ago (2009-11-22 04:49:00)
by turbo79
Hi All, I'm using SQL Server 2008. I used sql server management studio to create a table. I'd like to create a column "foobarID" and have the database insert and auto increment an int into that field each time a new record is added to that table. Can do? Thanks, Robert
Started 4 days, 10 hours ago (2009-11-21 17:56:51)
by ghassan_aljabiri
hello my table is filled with 10000 records it has no PK now i need to add a new field of bigint it should be an identity field (seed=1,increment=1) it should be a PK too , where sould i start Regards
Started 6 days, 9 hours ago (2009-11-19 18:37:00)
by debalina:)
Suppose for EMPLOYEE table we have two columns, EMPLOYEE_ID NUMBER(5) and EMPLOYEE_NAME VARCHAR2(200), now suppose both are unique, no two "DEBALINA ROY" are present in the EMPLOYEE_NAME column, every name is unique, In spite of the uniqueness of EMPLOYEE_NAME we create the primary key genrally on the EMPLOYEE_ID column, why? Is it for any performance...
Started 6 days, 23 hours ago (2009-11-19 05:21:00)
by rsilbert
Hello, I'm new to drupal and web development in general, but an experience programmer in C# and C++. I'm creating a new module that define a new node type and I want to add a couple of tables to the node for specific information beyond the basic node fields. I'm using the Schema API to create my table definitions and I need some clarity as what and how drupal uses Primary Keys, Unique ...
Started 1 week, 1 day ago (2009-11-17 06:54:00)
by Ryan
Hello, I have a db with two tables that have a one-to-many relationship. I also have a form with related sub-form for entering data into these tables. The tables were imported from an existing excel table and due to the nature of the data (one-to-many relationship for example) there was no way that I could make the primary key an arbitrary number. Instead I concatenated multiple...
Started 1 week ago (2009-11-18 06:50:00)
by AliRezaGoogle
Dear All, If a table column has UNIQUE INDEX and has NOT NULL property, is it equivalent to a PRIMARY KEY column? I guess the answer is yes if we ignore clustering (PK = Clusterd, While other indexes may not be clustered) Any idea is welcomed
Started 1 week ago (2009-11-18 10:12:00)
by Tibor Karaszi
If you're asking whether a foreign key can refer to a column which is UNIQUE (and not PK) then the answer is "yes". There is nothing special about this. Signature Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > Kalen, Jeroen and Tibor Thanks you all. Best answers I got here. > And for the sake of safety, is there ...
Started 1 week, 1 day ago (2009-11-18 01:46:00)
by DB Team
Hi, How to delete Primary key created in design view of a table with 35 Million records.. how long it will take to drop it??? Pls suggest me... Thanks in advance..
Started 1 week ago (2009-11-18 09:27:00)
by DB Team
Hi, I have 70million records table having email column.I want to add primary key to email column. please suggest me the efficient way to do this in sqlserver 2005. Thanks in advance...
Started 6 days, 23 hours ago (2009-11-19 05:12:00)
by sql baby
I have 2 tables with composite primary keys as follows:- StagingTable CustomerNo,Source,Address1,Address2 MasterTable CustomerNo,Source,Address1,Address2 Some CustomerNos here have multiple addresses thus Using this combination (composite key) is the only way to ...
Started 1 week, 1 day ago (2009-11-17 23:26:00)
by AliRezaGoogle
Dear All, If a table column has UNIQUE INDEX and has NOT NULL property, is it equivalent to a PRIMARY KEY column? I guess the answer is yes if we ignore clustering (PK = Clusterd, While other indexes may not be clustered) Any idea is welcomed .
Started 1 week, 1 day ago (2009-11-18 02:46:00)
by Tibor Karaszi
If you're asking whether a foreign key can refer to a column which is UNIQUE (and not PK) then the answer is "yes". There is nothing special about this.
Started 3 days, 1 hour ago (2009-11-23 03:15:00)
by David_Aldridge
Dird wrote: Hi, It means it's a B*Tree rather than Bitmap index. Mike ... or function-based normal/bitmap or domain. http://download.oracle.com/docs/cd/B19306_01/serve r.102/b14237/statviews_1069.htm#i1578369
Started 3 days, 20 hours ago (2009-11-22 07:52:00)
by RPG
Hello The Form navigator acts partly like a directory tree. When your form document have more forms then one, then you can get a problem as you have. In the form navigator you can see how much forms you have in your document. A form in the form navigator is bound to a table or query. All control who must be display field from that table must be in the same form. If they are not in ...
