Post reply

T-SQL Table Creates ???????????

  • April 25, 2002 at 11:07 am

    #158319

    ANYONE know of a way to generate Create Table scripts from T-SQL for tables that already exist in the database?? Withut going to Enterprise Manager?

    Thanks !!!!

    Jim

  • April 25, 2002 at 11:37 am

    #427866

    Be easy to write something. You could query systables and syscolumns to get the data.

    Or you could use sp_OACreate to create a DMP object and use that.

    Steve Jones

    steve@dkranch.net

  • April 25, 2002 at 12:03 pm

    #427870

    I have some partial unfinished code that does that but have not had time to finish it. Querying the nsystables and syscolumns also does not give you the nice index pieces or the filegroups locations and many other buzz pieces that EM gives you. Have not tried sp_OACreate and may do the job but if I get a chance I take a look at my code again in the next few days.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply