• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 683
  • Last Modified:

Compact Database?

I have used foxpro before and we used the "zap" command to compact the databases.  Is there a similar command in sybase or is it even necessary for a sql database?
0
vcab
Asked:
vcab
  • 2
1 Solution
 
Jan FranekCommented:
What Sybase database server do you have - ASE (Adaptive Server Enterprise) or ASA (Adaptive Server Anywhere) ?
0
 
vcabAuthor Commented:
Adaptive Server Anywhere 7.0.2.15
0
 
Jan FranekCommented:
Well it is not necessary to compact ASA database. However, sometimes it's good to create new clean database and then there are same useful utilities like rebuild or dbunload. For detailed info you can check http://sybooks.sybase.com/onlinebooks/group-aw/awg0700e/dbrfen7/@Generic__BookView;lang=cs
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now