Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the equivalent of the oracle query SET UNUSED (Column_name) in SQL server

Tags:

sql

sql-server

What is the equivalent of the oracle query SET UNUSED (Column_name) in SQL server?

    ALTER TABLE table_name
    SET UNUSED (column_name);

Also am looking for SQL equivalent for the dropping Unused column

    ALTER TABLE table_name
    DROP UNUSED COLUMNS;

Could someone please let me know the SQL equivalent of the above oracle statements.

like image 212
Princess S Avatar asked Dec 03 '25 05:12

Princess S


1 Answers

Sorry, apples and oranges.

There is no equivalent statement in SQL Server.

SQL Server doesn't have a mechanism for marking columns as "unused," which is an Oracle extension of SQL.

like image 180
Curt Avatar answered Dec 05 '25 20:12

Curt



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!