Results 1 to 3 of 3

Thread: Create Tabel sc

  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Lightbulb Create Tabel sc

    How can I get the script of a table.i.e 'CREATE TABLE' script.
    1. One way is to get this script from SQL Analyzer.
    but I m having tables created in the database and I want the My Stored Procedure should build the script and return it to me ...

    How could I achieve that ?

    Thankx in advance...

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Try call scptxfr.exe in master..xp_cmdshell.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •