GetTableDetails Function For MSSQL

Mar 20, 2012 at 12:39 PM

There may be two tables with the same name but in different schemas. I think the where clause at the ver and should be like this, i have added the underlined line. If schema is not used then grid is filled with mutliple table rows.

 

where c.table_name = '{0}'
 and c.table_schema = '{1}'
order by c.table_name, c.ordinal_position

Hope, i didn't miss anything.

Thanks you for this tool.

 

can