Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread DROP vs ALTER
Tue, Feb 10 2009 4:46 PMPermanent Link

Dale Derix
Hello:

In http://www.elevatesoft.com/edb_faqt_2.htm, it states that to change the path of a
defined database that has been moved, to DROP the database, then CREATE DATABASE with the
new path.

However, at the bottom it also states that as of v1.06 you can simply use the ALTER
DATABASE statement instead.

Which one is better to use?

Which one is faster?

Thanks,

Dale
Tue, Feb 10 2009 6:46 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dale,

<< Which one is better to use? >>

Use the ALTER DATABASE statement.  It's quicker and simply changes the path.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image