home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,245 of 19,505   
   Erland Sommarskog to Jim   
   Re: Commenting a table   
   16 Jun 17 07:02:11   
   
   From: esquel@sommarskog.se   
      
   Jim (jgeissman@socal.rr.com) writes:   
   > I have a table that contains the criterion values for a statistical test   
   > I use in a couple of places. In the code that uses the table I have a   
   > comment that describes how the table was populated, and how its values   
   > should be used. I would rather have that comment in the table itself, so   
   > if someone calls up the table to modify it, or has SQL produce the   
   > CREATE code, the comment will be there. Is it feasible to include a   
   > comment in CREATE TABLE that will persist with the table?   
   >   
      
   The code for CREATE TABLE is not saved in the database, so that as such   
   would not work out. However, you can use extended properties to enter   
   information about the table or various columns. You can enter them from   
   Object Explorer in SSMS or use sp_addextendedproperty.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca