Post reply

Getting the Create Table sql script

  • October 1, 2005 at 6:27 pm

    #95359

    I'm looking for a way of getting the create table sql script.

    In mysql i use to do it with "SHOW CREATE TABLE table_name", but i cannot find any equivalent in mssql.

    Is there a SP that dose this?

    i'm new to mssql, so dont be very hursh with me

    thanks

  • October 1, 2005 at 7:15 pm

    #594460

    In SQL Server it is easier right click on the table in the object browser in Query Analyzer then click on script object to new window then select create and you have your create table statement of your existing table.  Hope this helps.

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

  • October 1, 2005 at 7:23 pm

    #594461

    i know this, but i need to do this form my app automatically and not from any visual tool.

  • October 1, 2005 at 7:46 pm

    #594463

    I think you need sp_help.  Run a search for sp_help in the BOL (books online).  Hope this helps.

    sp_help [ [ @objname = ] name ]

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

  • October 1, 2005 at 8:14 pm

    #594464

    Try a little sql dmo. there is no 1 command in t-sql to do it.

    http://www.sqlservercentral.com/columnists/awarren/lotsoftablesandalittledmo.asp

     

Viewing 5 posts - 1 through 5 (of 5 total)

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