Professional Web Applications Themes

Enumerating Meta Information - Microsoft SQL / MS SQL Server

What is the API and Function to retrieve the comments associated with each field I define in the SQL/Server Client interface when defining a new record? Thanks, Siegfried...

  1. #1

    Default Enumerating Meta Information

    What is the API and Function to retrieve the comments associated with each
    field I define in the SQL/Server Client interface when defining a new
    record?
    Thanks,
    Siegfried


    Siegfried Guest

  2. #2

    Default Re: Enumerating Meta Information


    Maybe! Is that ADOX, SQLDMO or some other api? Is it a function or
    constant?


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Siegfried Guest

  3. #3

    Default Re: Enumerating Meta Information

    It is a function within SQL Server. Both sp_addExtendedProperty and
    fn_listextendedproperty are doented in Books Online. Here is a sample,
    which uses code to te adding a "description" value to a column via
    the GUI in Enterprise Manager...


    CREATE TABLE [dbo].[fakeUsers]
    (
    [name] [VARCHAR] (32)
    )
    GO

    EXEC sp_addextendedproperty
    N'MS_Description',
    N'blah blah',
    N'user',
    N'dbo',
    N'table',
    N'fakeUsers',
    N'column',
    N'name'
    GO

    SELECT value
    FROM ::fn_listextendedproperty
    (
    NULL,
    'user',
    'dbo',
    'table',
    'fakeUsers',
    'column',
    'name'
    )
    WHERE NAME='MS_Description'
    GO

    DROP TABLE fakeUsers
    GO



     


    Aaron Guest

  4. #4

    Default Re: Enumerating Meta Information

    So if I'm coding in C# or C++, would you recommend calling the stored
    procedure or is there a more direct way?
    "Aaron Bertrand - MVP" <com> wrote in message
    news:u#phx.gbl... 
    >
    >[/ref]


    Siegfried Guest

Similar Threads

  1. Enumerating list of IP Addresses from a given range
    By Brian Burns in forum PERL Beginners
    Replies: 8
    Last Post: May 28th, 06:44 PM
  2. enumerating all the paths in acyclic graph
    By Mikito Harakiri in forum IBM DB2
    Replies: 1
    Last Post: August 6th, 03:30 PM
  3. Meta Information on Page
    By Murray *TMM* in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 14th, 12:56 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139