Home » SQL & PL/SQL » SQL & PL/SQL » Unused Column
Unused Column [message #23669] Mon, 23 December 2002 23:47 Go to next message
mohamed
Messages: 27
Registered: November 2001
Junior Member
Hi,
I have made a column "unused". I would like to make it reuseable.
Can I know the command for it.

Thanx,

Report message to a moderator

Re: Unused Column [message #23670 is a reply to message #23669] Tue, 24 December 2002 00:17 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
It is not possible to "reuse" a column that has been marked as unused.

Report message to a moderator

Thanx, any work around???? [message #23671 is a reply to message #23670] Tue, 24 December 2002 01:58 Go to previous messageGo to next message
mohamed
Messages: 27
Registered: November 2001
Junior Member
Todd, is there any work around for that.

Report message to a moderator

Re: Thanx, any work around???? [message #23672 is a reply to message #23670] Tue, 24 December 2002 07:51 Go to previous message
sri
Messages: 154
Registered: February 2000
Senior Member
Marking a column unused is as good as DROPPING it.
It is an alternative to drop usage. Why use unused versus drop? is because unused is faster on large tables.

Work around is simply adding the same column to the table. But there would be couple of caveats,

1. Column's data is gone.
2. Column is added at the end of the table.

Thx,
Sri

Report message to a moderator

Previous Topic: How to return cursor from a stored procedure
Next Topic: How to write a Matrix report use SQL syntax ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 03:52:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.