Results 1 to 3 of 3

Thread: Create Tabel sc

Hybrid View

  1. 10-24-2005, 04:58 AM #1
    sandeepa
    sandeepa is offline Registered User
    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...
    Reply With Quote Reply With Quote
  2. 10-24-2005, 09:32 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Try call scptxfr.exe in master..xp_cmdshell.
    Reply With Quote Reply With Quote
  3. 10-24-2005, 10:07 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can use T-SQL too.

    http://www.databasejournal.com/featu...le.php/2205291
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules