Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6

    Unanswered: Thoughts on doing updates through SQL to system properties?

    Such as description notes for table and columns.

    I know where you can change them at the GUI level, but I was wondering if you recommend or ever have updated these fields using a update query?

    I am trying to go back into the tables that were created and document the tables and columns. Most of them have not been so I built the system query to capture a lot of the attributes for tables and columns, manually. I was going to update the NULLS in the descriptions with my new descriptions.

    Kind regards
    V

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Where can you change them in the GUI?
    Most things in SSMS can be scripted out (check out the top of the window you're working in).
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    Right click on the column or table (go to properties), then go to extended properties. There you can change the notes.

    Add notes or modify.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Okay, so go do that, but instead of clicking "OK", click on the "Script" button at the top.
    Have a look at the script generated.
    George
    Home | Blog

  5. #5
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    Thanks! I'll check it out!

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    The point I'm getting to here is that you should use the same code that SSMS does. Don't roll your own.

    System tables shouldn't be toyed with
    George
    Home | Blog

  7. #7
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    Yeah but I don't know any better so it makes it okay.

Posting Permissions

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