Generate script to create table but on all on different files

• Virender Sihag

  Say Hey Kid

  Points: 688

  More actions

  July 25, 2011 at 10:37 pm

  #99748

  hi,

  I want to have drop and create query for all the tables in my database, but i want to have separate object on separate file.

  i am not sure is it possible or not??:-)

  [font="Arial Narrow"]Failure is not the worst thing. The worst Thing is not to try[/font]

• M&M

  SSC-Insane

  Points: 21699

  More actions

  July 25, 2011 at 11:12 pm

  #1358243

  I am not sure if I understood your question fully but did you try making use of SSMS for scripting out the tables?

  M&M

• Vishal.Gajjar

  SSCrazy

  Points: 2285

  More actions

  July 26, 2011 at 1:56 am

  #1358278

  Hi Virendar,

  You can generate scripts for DROP and CREATE using SSMS. but you will need to manually edit the script to change the ON clause.

  Vishal Gajjar
  http://SqlAndMe.com