Fuzbe's avatar
Fuzbe
New Member
10 years ago
Status:
Needs Votes

View System / Dictionary tables in RDBMS

Would like to connect to dictionary tables in Oracle, SQL Server etc...

3 Comments

  • dbrowne's avatar
    dbrowne
    Microsoft Employee
    You can always write custom against the system tables if you need this.
  • syvargas's avatar
    syvargas
    Microsoft Employee
    Most SQL like databases implement the SQL COMMENT (SQL Server has extended properties not quite the same). Implementing functionality that can leverage the COMMENT documentation from the database to annotations or tool tips would help novice users to see the "dictionary" to make some better decisions in reporting instead finding people to understand the data. Good method to also encourage documenting of the report contents. https://www.postgresql.org/docs/9.5/static/sql-comment.html https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4009.htm

Recent ideas