June 18, 2009 at 2:29 pm
My manager asked me to update the column description for data dictionary. IS there any fastest way to update the whole table columns at once besides diagram and EXEC sys.sp_addextendedproperty ? can some one please give me few options?
Will it be a space issue? I have to update two databases.it’s around 1400+ entries. Is there any procedure or way to get the report? Thanks
June 18, 2009 at 2:38 pm
adding extended property wont take time. also how many tables do u have? 1400? in this case i guess u'll need to add the property for each of them if they are different. Or if you can create a table with table name and description, you can write a query that can loop through all tables and add the extended property..
June 18, 2009 at 2:44 pm
Thank you and any query example would help-
June 18, 2009 at 2:46 pm
http://msdn.microsoft.com/en-us/library/ms180047.aspx has many examples. which object do u want to add extended property to? tables? columns?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply