Sql-server – It is possible to extract Extented Properties using SQL Developer Data Modeler

sql-server-2008-r2

I'm using SQL Developer Data Modeler in a oracle server. No problem, I can connect to SQL Server, list tables and generate a really good report. But what I need is to extract the extended properties from tables and columns. I'm looking all over the internet but what I found is:

MS SQL Server
Support for following objects – database, login, user and roles with their privileges and permissions, default, rule, user-defined type, computed and identity columns, partitioned tables using partition function and partition scheme, primary and secondary XML indexes, triggers on tables and views, stored procedures, indexes on views, synonyms
    Domains can be created as user-defined types
    **Extended properties for each object can be defined and generated in DDL**
    Database and schema controlled generation of DDL

http://www.oracle.com/technetwork/developer-tools/datamodeler/featurelist-167684.html

From the official manual. But I don't want to generate manually the properties with the software. I have already all properties of extended properties from almost all tables.

Or can I make a Data Dictionary with my good SQL Server Management Studio? I can only see reports from disk usage, performance metrics and etc.

This is what I have for now:

enter image description here

Best Answer

I'm not sure I understand what your use case is, but you can retrieve them by querying the sys.extended_properties system view.

SSMS doesn't provide a helpful way to view extended properties outside of the individual dialogue window for a single object anyways, so this is probably your best route.

Neither tool will be able to build you a data dictionary necessarily, but you can generate a simple one by querying from any tool.

Related Question