Hello, everyone, I'd like to drop table delete thousands sybase database table, because too many, manually add go too slow, the man went to guide, how to do it faster? There are no other better way to remove? Thank you for your attention!

CodePudding user response:

Using a select statement to structure your statement execution,
Select "drop table" + name + char (13) + 'go' + char (13) from sysobjects where type='U' and...
Thinking about that