# Setting primary key \[May 03\] **URL:** \ **Category:** Discord-Discussions\ **Created:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414 "2022-11-03T09:30:29Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/1 "2022-11-03T09:30:29Z")
[dummy title body text appended to avoid empty title body] ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/2 "2022-11-03T09:30:30Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### are u saying if set the primary key when creating the column but it shows not PK after the creation? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/3 "2022-11-03T09:30:31Z")
> πŸ™‹β€β™‚οΈ **Shard** _replied_ #### I deleted the Id column and now my table has no PK and nocodb wont let me edit the table # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/4 "2022-11-03T09:30:32Z")
> πŸ™‹β€β™‚οΈ **Shard** _replied_ #### Now I want to make another column into PK but apparently β€œSet as Primary value” doesn’t do it # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/5 "2022-11-03T09:30:34Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### u need to create a column with PK ticked # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/6 "2022-11-03T09:30:35Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### like i said before, primary value is different than primary key # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/7 "2022-11-03T09:30:36Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### see the screenshot i sent # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/8 "2022-11-03T09:30:37Z")
> πŸ™‹β€β™‚οΈ **Shard** _replied_ #### I get an error when I try to create a new column with PK ticked: `multiple primary keys for table "table_name" are not allowed` # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/9 "2022-11-03T09:30:38Z")
> πŸ™‹β€β™‚οΈ **Shard** _replied_ #### I dropped the existing PK with postgres query, but creating a new column with PK ticked still doesn’t work. Tells me: `column "name" of relation "table_name" contains null values` # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/10 "2022-11-03T09:30:39Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### did u hv records? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/11 "2022-11-03T09:30:40Z")
> πŸ™‹β€β™‚οΈ **Shard** _replied_ #### What do you mean? # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/12 "2022-11-03T09:30:42Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### i just tried it n it works fine # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/13 "2022-11-03T09:30:43Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### does your table contain some records before u create new PK # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/14 "2022-11-03T09:30:44Z")
> πŸ™‹β€β™‚οΈ **Shard** _replied_ #### Yes it is an existing table # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/15 "2022-11-03T09:30:46Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### then u may feed the default value # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/16 "2022-11-03T09:30:48Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### try sth like this ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/783fe6d5b68b20859dfea679c06398287f790bb5.png) # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/17 "2022-11-03T09:30:49Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### tick NN to mark it not null #### tick PK to make it Primary key #### add default value to make existing records to hv a PK value # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/18 "2022-11-03T09:30:50Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### then u can change it afterwards # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/19 "2022-11-03T09:30:52Z")
> πŸ™‹β€β™‚οΈ **Shard** _replied_ #### Getting this: `ALTER TABLE "table_name" ADD "name" character varying NOT NULL DEFAULT placeholder;;alter TABLE "table_name" add constraint "table_name_pkey" PRIMARY KEY("name"); - cannot use column reference in DEFAULT expression` # ---
**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\ **Post date:** [November 3, 2022, 9:30am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/20 "2022-11-03T09:30:53Z")
> πŸ™‹β€β™‚οΈ **wkw** _replied_ #### can u screencap your input like i did # [Next page](https://community.nocodb.com/t/setting-primary-key-may-03/414.md?page=2)