on 01-28-2016 8:08 PM
I'm generating DDL for SQL Server and want to load extended properties into the database. I checked off the "Comment" box on tables and columns in the Database Generation Options tab. I get this
execute sp_addextendedproperty 'MS_Description',
'Hierarchy of the Programs, Program Components balh, blah, blah.',
'user', 'JAN', 'table', 'AH_PROGRAM_COMPONENT_CATEGORY'
go
Of course the 'user' value should be 'SCHEMA'. If I edit it, it works fine.
How do I get in behind the DDL generation instructions within PD to correct this permanently?
Regards,
Jane
Ok. Figured it out. For the benefit of others reading this later, go to Tools --> Resources --> DBMS then choose SQL Server 20nn edit the script for Table Comment and Column Comment and View Comment.
Save the file.
Done.
JR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jane,
You beat me to it. I was just about to post the same. Glad you figured it out.
Here's some additional info from Microsoft in relation to this on SQL Server 2008:
http://technet.microsoft.com/en-us/library/ms143729%28SQL.100%29.aspx
- Use Level0type = 'USER' only to add an extended property directly to a user or role.
- Use Level0type = 'SCHEMA' to add an extended property to level-1 types such as TABLE or VIEW, or level-2 types such as COLUMN or TRIGGER. For more information, see sp_addextendedproperty (Transact-SQL)
Adam
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.