# Removed old column name(vendors\_id) from database but on Nocodb UI it is asking for the column **URL:** \ **Category:** Integrations\ **Tags:** data-import-export\ **Created:** [July 17, 2024, 7:27pm UTC](https://community.nocodb.com/t/removed-old-column-name-vendors-id-from-database-but-on-nocodb-ui-it-is-asking-for-the-column/1278 "2024-07-17T19:27:47Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![weintegral](https://avatars.discourse-cdn.com/v4/letter/w/c77e96/32.png) [@weintegral](https://community.nocodb.com/u/weintegral)\ **Post date:** [July 17, 2024, 7:27pm UTC](https://community.nocodb.com/t/removed-old-column-name-vendors-id-from-database-but-on-nocodb-ui-it-is-asking-for-the-column/1278/1 "2024-07-17T19:27:47Z")
I removed column named “vendors\_id” from database . But nocodb requesting for the removed column ```auto select " __nc_root"."id" as "corc0qszl073s25", "__ nc_root"."technology" as "cglbtz63oqxjuog", " __nc_root"."recruiters_id" as "cjizis3qfxjianj", "__ nc_root"."consultants_id" as "ci84dll9e4tr20n", " __nc_root"."rate" as "caducklutoq9iwj", "__ nc_root"."status" as "cq6xhflk89mpci9", "__nc_root"."created_at" AT TIME ZONE CURRENT_SETTING('timezone') AT TIME ZONE 'UTC' as "c1vcew530n8y8pe", "__nc_root"."updated_at" AT TIME ZONE CURRENT_SETTING('timezone') AT TIME ZONE 'UTC' as "c0voh8a032fg8hn", "__nc_0"."cle23xdegsjrscr", (select count("__nc_rollup"."submissions_id") from "public"."notes" as " __nc_rollup" where "__ nc_root"."id" = "__nc_rollup"."submissions_id") as "cfa1nigowvnvjan", "__nc_3"."cxrscoi97nvzyo9", "__nc_6"."ciie15fn7cm7nxm" from (select * from "public"."submissions" order by "id" asc limit 100 offset 0) as "__nc_root" LEFT OUTER JOIN LATERAL (select json_build_object('cxkz54ol2ms2kfo'," __nc_1"."cxkz54ol2ms2kfo",'csjfqx0pifgmove',"__ nc_1"."csjfqx0pifgmove") as "cle23xdegsjrscr" from (select " __nc_2"."id" as "cxkz54ol2ms2kfo", "__ nc_2"."first_name" as "csjfqx0pifgmove" from (select * from "public"."employees" where "id" = "__nc_root"."recruiters_id" limit 1) as "__nc_2") as "__nc_1") as "__nc_0" ON true LEFT OUTER JOIN LATERAL (select json_build_object('caspe8adyy55wue'," __nc_4"."caspe8adyy55wue",'cuw4ouseuz2zb55',"__ nc_4"."cuw4ouseuz2zb55") as "cxrscoi97nvzyo9" from (select " __nc_5"."id" as "caspe8adyy55wue", "__ nc_5"."first_name" as "cuw4ouseuz2zb55" from (select * from "public"."consultants" where "id" = "__nc_root"."consultants_id" limit 1) as "__nc_5") as "__nc_4") as "__nc_3" ON true LEFT OUTER JOIN LATERAL (select json_build_object('calzhyes8p5k9oo'," __nc_7"."calzhyes8p5k9oo",'c1l1ls1syv3x18s',"__ nc_7"."c1l1ls1syv3x18s") as "ciie15fn7cm7nxm" from (select " __nc_8"."id" as "calzhyes8p5k9oo", "__ nc_8"."first_name" as "c1l1ls1syv3x18s" from (select * from "public"."recruiters" where "id" = "__nc_root"."vendors_id" limit 1) as "__nc_8") as "__nc_7") as "__nc_6" ON true order by " __nc_root"."id" asc - column__ nc_root.vendors_id does not exist ``` ---
**Author:** ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)\ **Post date:** [July 17, 2024, 7:32pm UTC](https://community.nocodb.com/t/removed-old-column-name-vendors-id-from-database-but-on-nocodb-ui-it-is-asking-for-the-column/1278/2 "2024-07-17T19:32:40Z")
Was this an external database from which you removed the column. If so, you will have to do a [meta sync](https://docs.nocodb.com/data-sources/sync-with-data-source/). Else if its internal database on our cloud. Please provide your the URL or workspace\_id (see attached image). ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/d0c2e479f3c250d6058fc0d22de17db71aec97d5.png) ---
**Author:** ![weintegral](https://avatars.discourse-cdn.com/v4/letter/w/c77e96/32.png) [@weintegral](https://community.nocodb.com/u/weintegral)\ **Post date:** [July 18, 2024, 1:00pm UTC](https://community.nocodb.com/t/removed-old-column-name-vendors-id-from-database-but-on-nocodb-ui-it-is-asking-for-the-column/1278/3 "2024-07-18T13:00:24Z")
Thanks it resolved my issue.