---
title: "SQL - Delete a column from a table without changing the environment"  
description: "SQL - Delete a column from a table without changing the environment"  
author: "Anonymous User"  
published: 2013-05-02  
updated: 2013-05-02  
canonical: https://www.mindstick.com/forum/786/sql-delete-a-column-from-a-table-without-changing-the-environment  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# SQL - Delete a column from a table without changing the environment

Hi Everyone!\
I'm working in a [Oracle](https://www.mindstick.com/articles/13016/alter-table-statement-or-command-in-oracle) [SQL database](https://www.mindstick.com/articles/337535/connecting-to-sql-databases-ado-dot-net-essentials), quite big database. One of (among 150 tables) this table has to be changed because it's redundant (it can be generated through a join). I'm asked to delete a column from this table, to get rid of the redundancy. The problem is that now I have to change code [everywhere](https://yourviews.mindstick.com/view/80697/bjp-losing-ally-everywhere) someone made a [insert](https://www.mindstick.com/blog/173/executing-insert-delete-or-update-query-in-sqlserver-using-ado-dot-net)/[update](https://www.mindstick.com/forum/156353/what-is-hummingbird-update)/etc on this table (and don't forget the contraint!). I thought "I can make a view that do the [right join](https://www.mindstick.com/blog/304465/difference-between-inner-join-left-join-right-join-and-full-outer-join-in-sql-server)" so the problem it's solved for all the select, but it's not working for the insert, because I'm updating 2 tables... Is there a way to [solve this problem](https://answers.mindstick.com/qa/94681/my-google-assistant-shows-completely-different-search-results-from-what-i-ask-how-can-i-solve-this-problem)? My goal is to rename my original table "original_table" in "original_table_smaller" (with one less column) and create a view (or something like a view) called "original_table" that work like the original table. Is this possible? \
Thanks!

## Replies

### Reply by AVADHESH PATEL

Hi Goti!\
\
Check with this query:\
\
select * from user_updatable_columns where table_name = 'VIEW_NAME';


---

Original Source: https://www.mindstick.com/forum/786/sql-delete-a-column-from-a-table-without-changing-the-environment

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.