What is the difference between dropping a column with the DROP COLUMN clause and setting a column as ...

kekule

wrote...

Posts: 687

Rep:

6 years ago

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as ...

What is the difference between dropping a column with the DROP COLUMN clause and setting a column as unused with the SET UNUSED clause?

Read 76 times

1 Reply

Report

Related Topics

Solved The DISTINCT keyword in a SELECT clause operates on a column by column level.
Solved Any column contained in a SELECT clause where there is an aggregate function and where that column ...
To add a new column, use the ADD NEW COLUMN clause of the ALTER TABLE command.
Solved When a multiple-column subquery is used in the WHERE clause of the outer query, the column names ...
Solved When a multiple-column subquery is included in the outer query's WHERE clause, the column names ...
Solved When a multiple-column subquery is used in the WHERE clause of the outer query, the column names ...
Solved If an individual column is listed in a SELECT clause, along with a group function, the column must ...
Solved If more than one column is listed in the INSERT INTO clause, the column names must be separated by ...

Replies

pianoman314

wrote...

6 years ago

When a column is dropped with the DROP COLUMN clause, the storage space occupied by the data is freed up immediately. However, with the SET UNUSED clause, the column is unavailable, but the storage space it occupies is not released until the DROP UNUSED COLUMNS clause is executed.

Report

New Topic

Quick Reply

Explore

Post your homework questions and get free online help from our incredible volunteers

1013 People Browsing

159 Signed Up Today

Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook

Live Chat

AJAX Chat © blueimp.net Integrated with SMF

Related Images

148

160

322

Your Opinion

Previous poll results: What's your favorite funny biology word?

Courses by Biology Forums

It's sore throat season, why does my mucus have red spots?

Strange Ingredients Lurking in Doritos Chips

Bonobos, Chimpanzees, and the 98% DNA Link

The Toxic Skin and Fungi Defense

Ready to ask a question on Biology Forums? Try it out

Home Search Q & A Board Gallery Resource Library Blog Dictionary Chat	Quick Links Start a Topic Latest Topics Unanswered Questions Courses Study Tools Browse by Textbook	Social Facebook YouTube Community Stats Who's Online Trending Staff	Help About Us Take the Tour Study Tips Posting Guidelines Terms and Policies Contact Us
Biology Forums - Study Force © 2010-2024 \| Powered by SMF \| SMF © 2015, Simple Machines \| Sitemap Biology-Forums.com is not affiliated with any publisher. Book covers, title and author names appear for reference only.