Home Forums SQLServerCentral.com Anything that is NOT about SQL! copy Database properties in Visio into clipboard ? RE: copy Database properties in Visio into clipboard ?

  • February 25, 2010 at 8:19 am

    #1125025

    Franky Leeuwerck (2/25/2010)

    Hi,

    Does anyone know how to copy the information from the columns pane in the Database Properties window of a table entity in Visio?

    Specifically on the columns page, I would like to select all rows (all columns) and copy the contents (including the notes column) to my clipboard for further use in let's say a document.

    I can copy each individual cell in that pane, but not the whole selection.

    Thanks for any tips.

    Regards,

    Franky

    Those properties are part of the Microsoft database management object, that is in 2000 and below you use DMO now you use SMO. So you need to look for T-SQL script used to generate it or write SMO code because tools from Microsoft partners can be used to generate it.

    Kind regards,
    Gift Peddie