Generate Script with DROP clause only

Generate Script with DROP clause only

Postby SQL4Fun » Fri 31 Oct 2014 10:02

Hi,


I want to generate a script containing only
DROP TABLE xxxx orders.

I only checked the options I thought usefull (below, there is an excerpt of the project file), but it remains the CREATE TABLE orders.
Any ideas ?

Thanks in advance for replying.
regards.

JL.
----
<PropertyValue Name="FormatDdlText">true</PropertyValue>
<PropertyValue Name="UseCreateOrReplace">false</PropertyValue>
<PropertyValue Name="UseSchemaNamePrefix">false</PropertyValue>
<PropertyValue Name="GenerateComments">false</PropertyValue>
<PropertyValue Name="IncludeDrop">true</PropertyValue>
<PropertyValue Name="IncludePurge">false</PropertyValue>
<PropertyValue Name="IncludeCascadeConstraints">true</PropertyValue>
<PropertyValue Name="UseDelimiter">false</PropertyValue>
<PropertyValue Name="SplitAlterTable">false</PropertyValue>
<PropertyValue Name="IncludeConstraints">false</PropertyValue>
<PropertyValue Name="DisableConstraints">false</PropertyValue>
<PropertyValue Name="IncludeTriggers">false</PropertyValue>
<PropertyValue Name="IncludeIndexes">false</PropertyValue>
<PropertyValue Name="IncludeComments">false</PropertyValue>
<PropertyValue Name="IgnoreColumnDefaultValues">false</PropertyValue>
<PropertyValue Name="IncludeColumnsOnly">false</PropertyValue>
<PropertyValue Name="IncludePartitionClause">false</PropertyValue>
<PropertyValue Name="ListIndividualHashPartitions">false</PropertyValue>
<PropertyValue Name="IncludeEncryptedPassword">false</PropertyValue>
<PropertyValue Name="IncludeObjectGrants">false</PropertyValue>
<PropertyValue Name="IncludeGrants">false</PropertyValue>
<PropertyValue Name="IncludeUserInfo">false</PropertyValue>
<PropertyValue Name="PlaceDataJustAfterTableDefinition">false</PropertyValue>
<PropertyValue Name="InsertCommit">false</PropertyValue>
<PropertyValue Name="InsertCommitAfter" xml:space="preserve">100</PropertyValue>
<PropertyValue Name="IncludeColumnNames">false</PropertyValue>
<PropertyValue Name="WriteLog">false</PropertyValue>
<PropertyValue Name="LogFileName" xml:space="preserve">D:\Dev\_Scripts SQL\_En Cours\SchemaExport.log</PropertyValue>
<PropertyValue Name="ErrorHandlingMode">0</PropertyValue>
<PropertyValue Name="IncludeStorageClause">false</PropertyValue>
<PropertyValue Name="IncludePhysicalAttributes">false</PropertyValue>
<PropertyValue Name="IncludeBodies">false</PropertyValue>
<PropertyValue Name="IncludeConnectCommand">false</PropertyValue>
<PropertyValue Name="ExcludeDollarContained">false</PropertyValue>
<PropertyValue Name="IncludeTablespaces">false</PropertyValue>
<PropertyValue Name="IncludeUseDatabase">false</PropertyValue>
<PropertyValue Name="RestoreUseDatabase">false</PropertyValue>
<PropertyValue Name="ExcludeStartNextForMView">false</PropertyValue>
<PropertyValue Name="IncludePartitionTablespace">false</PropertyValue>
<PropertyValue Name="IncludeIndexPartitionTablespace">false</PropertyValue>
<PropertyValue Name="ExcludePartitionListForLocalIndex">false</PropertyValue>
SQL4Fun
 
Posts: 3
Joined: Thu 25 Sep 2014 13:45

Re: Generate Script with DROP clause only

Postby alexa » Fri 31 Oct 2014 12:13

Unfortunately, there is no option to do this in dbForge. However, you can add a suggestion on our UserVoice forum where other users can vote for it http://devart.uservoice.com/forums/225134-devart-general

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.
alexa
Devart Team
 
Posts: 2171
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle