# Should I import the metadata ? after sync \[Apr 05\] **URL:** \ **Category:** Discord-Discussions\ **Created:** [November 3, 2022, 8:53am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348 "2022-11-03T08:53:59Z")\ **Posts on this page:** 16\ **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, 8:53am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/1 "2022-11-03T08:53:59Z")
> πŸ™‹β€β™‚οΈ **Kratos** _asked_ ## Hey everyone #### I’m using a Heroku PostgreSQL database for nocoDB and I have added around 5 tables. the tables work fine but I forgot to keep primary key for one table so then I connected to Heroku PostgreSQL on my pc and ran some sql commands to make one of the columns a primary key(i.e. alter table table\_name … ). I can confirm that the column is a primary key(checked the table multiple times) but it does not update in nocoDB as a primary key. #### #### I made only one of them as a primary key. The table had records before I kept it in nocoDB. I want to make it a primary key so I can edit/update the rows when im in nocoDB. #### #### Metadata is synced and I also refreshed the tables and it has been 6 hours since I made it a primary key, should I import the metadata then? need help… ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/2 "2022-11-03T08:54:00Z")
> πŸ’ **o1lab** _replied_ #### not necessary # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/3 "2022-11-03T08:54:01Z")
> πŸ’ **o1lab** _replied_ #### if its all synced # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/4 "2022-11-03T08:54:02Z")
> πŸ™‹β€β™‚οΈ **Kratos** _replied_ #### No what im trying to say is that its not synced because in nocoDB the said column is not a primary key and I cant edit the table. #### #### In reality the column is a primary key which I checked. # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/5 "2022-11-03T08:54:04Z")
> πŸ’ **o1lab** _replied_ #### ok, like all tables created in nocodb have a primary key - how was that missed ? # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/6 "2022-11-03T08:54:05Z")
> πŸ’ **o1lab** _replied_ #### may be you can take a screenshot and paste it here # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/7 "2022-11-03T08:54:06Z")
> πŸ’ **o1lab** _replied_ #### of what you are seeing in a db client and nocodb # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/8 "2022-11-03T08:54:07Z")
> πŸ’ **o1lab** _replied_ #### + primary keys are not shown by default #### you would have to hover on fields and click β€˜show system fields’ # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/9 "2022-11-03T08:54:09Z")
> πŸ™‹β€β™‚οΈ **Kratos** _replied_ #### ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/optimized/1X/5234e367f7a700a3a9dd7adac75999fc8ac43e52_2_690x43.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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/10 "2022-11-03T08:54:10Z")
> πŸ™‹β€β™‚οΈ **Kratos** _replied_ #### I can screen share if you want # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/11 "2022-11-03T08:54:11Z")
> πŸ™‹β€β™‚οΈ **Kratos** _replied_ #### ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/7fb3568a0a2d91a7f0988823589f6db814b67b66.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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/12 "2022-11-03T08:54:12Z")
> πŸ™‹β€β™‚οΈ **Kratos** _replied_ #### you see how token is a primary key but on nocoDB it does not show it as a 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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/13 "2022-11-03T08:54:14Z")
> πŸ™‹β€β™‚οΈ **Kratos** _replied_ #### this is one of the other tables that has memberId as a primary key ![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/1e14907e2ab3d8999437801d804a86d4d8319472.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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/14 "2022-11-03T08:54:15Z")
> πŸ™‹β€β™‚οΈ **Kratos** _replied_ #### Okay I fixed this issue # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/15 "2022-11-03T08:54:16Z")
> πŸ™‹β€β™‚οΈ **Kratos** _replied_ #### You need to clear the metadata at the project list in the dashboard page and then open the project. # ---
**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, 8:54am UTC](https://community.nocodb.com/t/should-i-import-the-metadata-after-sync-apr-05/348/16 "2022-11-03T08:54:18Z")
[Autogenerated from discord](https://discord.com/channels/661905455894888490/959812854570176572) * * * #### 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/)