SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Non-Member XX7509's Avatar
    Join Date
    Feb 2003
    Location
    Antarctica
    Posts
    568
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MS SQL: Need help generating a script

    Hi.

    I am using MS SQL Database. I have a huge database that I need to script and it has a ton of fields that cannot be very well named. I'm trying to keep the length of the field names somewhat short, I dont want a huge name

    admin_enable_registered_members_to_view_member_table

    I don't want to names that long so I made them really short and its hard to tell what data they hold if you didn't design the database, so I included a description of all the hard fields in the "description" field, but when I generate my script "All Tasks - Generate SQL Script" the descriptions are not included, how can I make them be included in the *.sql file?

    Thanks.

  2. #2
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hi
    when u start EM, and go to ALL TASK >> GENERATE SQL Scripts

    click the formatting option and check the check box, "INCLUDE DESCRIPTIVE HEADERS"

    rgds
    Afrika


Bookmarks

Posting Permissions

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