Toad World® Forums

Creation Script - How to remove "USE [Databasename]"

For some reason I cannot find the options in Toad 6.5 to turn off “SCRIPT USE”

In SSMS the option is under:

SQL Server Object Explorer

  • Scripting
  • General Scripting Options

"Script USE " and has a true/false setting.

I’m trying to turn this off. Where’s the setting in Toad 6.5?

Hi Darren,

Thanks for support. We can turn this off when we generate Data script and DDL script in Toad .

  1. Generate Data Script:

Right Click table->Generate SQL->Data Script ->Options ->Script Options-> Generate USE

  1. Right Click table->Generate SQL->DDL Script ->Options ->Generate USE Database

Thanks again.