Post reply

Create Table with Columns Descriptons or Comment.

  • November 24, 2006 at 12:01 pm

    #368082

    I ´d  like to know, How can I put comments or descriptions about the columns of table, because when I use Enterprise Manager in design table is possible to put the description of columns, but what´s the table have the resgister about my columns descriptions.  

  • November 25, 2006 at 8:32 am

    #673891

    Check out sp_addextendedproperty in books online.

  • November 27, 2006 at 6:52 am

    #674018

    Please,  Follow this eg. Steps on Enterprise Manager, at database Northwind,  Tables,  you click with right in Desin Table eg, ORDERS table,  show  the screen (Design Table ‘ORDERS’ in Northwind on server....), there is the Description columns for ORDERS table, you to put any description, eg. XXXXX,   what´s system table I find this description colunms with XXXXX ?. Ok!

     

    Thank´s

     

    Ian.

  • November 27, 2006 at 7:14 am

    #674030

    SELECT   *

    FROM   ::fn_listextendedproperty(NULL, NULL, NULL, NULL, NULL, NULL, NULL)

  • November 27, 2006 at 12:41 pm

    #674146

    Sorry, I did this command in query analyzer  in database Northwind for test, but all the columns are nulls, I think that some column must be with XXXXX at ORDERS table.

    Please , is possible you explain me this test, because my test dosen´t work ok!

  • November 27, 2006 at 12:59 pm

    #674149

    Check this out : http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply