Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikevanhoff
Starting Member
1 Post |
 Posted - 2006-07-21 : 11:47:48
|
| I am running Sybase 11.92. I want to reclaim white space in the database. I have the following process that works for a tableUSE ,database name>goALTER TABLE <table name> DATAROWSgoreorg reclaim_space <table name>goALTER TABLE <table name> ALLPAGESgoI have a text file with the names of all tables in the database. How can I pass the "<table name>" in the text file to the appropriate position in the commands above?Thanks in advance. |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-07-21 : 12:00:17
|
quote:
Originally posted by mikevanhoff
I am running Sybase 11.92. I want to reclaim white space in the database. I have the following process that works for a tableUSE ,database name>goALTER TABLE <table name> DATAROWSgoreorg reclaim_space <table name>goALTER TABLE <table name> ALLPAGESgoI have a text file with the names of all tables in the database. How can I pass the "<table name>" in the text file to the appropriate position in the commands above?Thanks in advance.
Even though sybase is similar to SQL Server, this is not the proper forum to discuss Sybase things...may be u can post it on some other forum like [url]dbforums.com[/url]Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
passing parameters