# Setting primary key \[May 03\]

**URL:** <https://community.nocodb.com/t/setting-primary-key-may-03/414>\
**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:** 12\
**Page:** 3

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/41 "2022-11-03T09:31:19Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### Here is one: [Can't create a new column with PK option · Issue #1947 · nocodb/nocodb · GitHub](https://github.com/nocodb/nocodb/issues/1947)

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/42 "2022-11-03T09:31:20Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### and the other: [🐛 Bug: Nocodb doesn't recognize the PK change made using database queries. · Issue #1948 · nocodb/nocodb · GitHub](https://github.com/nocodb/nocodb/issues/1948)

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/43 "2022-11-03T09:31:22Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### Is there any way I can make this table functional again while waiting?

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/44 "2022-11-03T09:31:23Z")

</div>

> 💁 **o1lab** _replied_

#### you can create project by reconnecting to the database

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/45 "2022-11-03T09:31:24Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### How would I do that? Doesn’t deleting a project also delete the db/tables associated with it?

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/46 "2022-11-03T09:31:25Z")

</div>

> 💁 **o1lab** _replied_

#### nope, deleting table is just meta - it wont delete your table in database

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/47 "2022-11-03T09:31:26Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### So I can safely do this?

![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/c7f1b5d36c387d24177b844cfa9ba8e9377e6989.png)

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/48 "2022-11-03T09:31:29Z")

</div>

> 💁 **o1lab** _replied_

#### ya

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/49 "2022-11-03T09:31:30Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### That did it. Also the column is now correctly shown as PK in nocodb

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/50 "2022-11-03T09:31:32Z")

</div>

> 🙋‍♂️ **Shard** _replied_

#### Should I add that info to the issue as well?

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/51 "2022-11-03T09:31:33Z")

</div>

> 💁 **o1lab** _replied_

#### yes, please do

#

---

<div class="post-metadata">

**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:31am UTC](https://community.nocodb.com/t/setting-primary-key-may-03/414/52 "2022-11-03T09:31:34Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/970455209455259698)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)

[Previous page](https://community.nocodb.com/t/setting-primary-key-may-03/414.md?page=2)
