Groups > comp.databases.ms-sqlserver > #1978

Re: Commenting a table

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Commenting a table
Date	2017-06-16 10:36 +0000
Organization	Erland Sommarskog
Message-ID	<XnsA79680E13D02FYazorman@127.0.0.1> (permalink)
References	<MPG.33acd793ba3ba35898969a@news.powerusenet.com> <XnsA7965C8A722AFYazorman@127.0.0.1> <343bf905-255b-483f-9c70-423b4a5e0dc4@googlegroups.com>

Show all headers | View raw

 (rja.carnegie@gmail.com) writes:
> Does that depend on the second developer taking
> an interest in extended properties?  Or does it
> just pop up in the script of the table definition?

That depends on how the table is scripted. Don't recall what the default
is for extended properties. (I have never used them myself.)
 
> My goofy suggestion is to include a computed 
> column called "about_this_table", that is defined 
> to consist of the comment text as a literal char
> string.
> 

That's what they call an interesting idea. :-)


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Commenting a table Jim <jgeissman@socal.rr.com> - 2017-06-15 18:43 -0700
  Re: Commenting a table Erland Sommarskog <esquel@sommarskog.se> - 2017-06-16 07:02 +0000
    Re: Commenting a table rja.carnegie@gmail.com - 2017-06-16 00:53 -0700
      Re: Commenting a table Erland Sommarskog <esquel@sommarskog.se> - 2017-06-16 10:36 +0000

csiph-web