SMO 172.52.0, skips generation of "hidden" tables. #190

Activity

1. shueybubbles commented on Feb 21, 2025

   

   David Shiflet (shueybubbles)

   on Feb 21, 2025

   Contributor

   More actions

   Per the XML definition of IsSystemObject, that EP is intended to mean that it's treated as a system table.

        <property name="IsSystemObject" type="bit" access='Read' cast = 'true'>
    case 
       when {0}.is_ms_shipped = 1 then 1
       when (
           select 
               major_id 
           from 
               sys.extended_properties 
           where 
               major_id = {0}.object_id and 
               minor_id = 0 and 
               class = 1 and 
               name = N'microsoft_database_tools_support') 
           is not null then 1
       else 0
   end          
               </property>
   

   I think the only relic feature that uses this EP is database diagrams:

   	declare @val int
   	select @val = 1
   	if NOT EXISTS(	select major_id 
   					from sys.extended_properties
   					where major_id = object_id(N'dbo.sysdiagrams') and class = 1 and minor_id = 0 and name = N'microsoft_database_tools_support')
   	begin
   		exec sp_addextendedproperty N'microsoft_database_tools_support', @val, 'SCHEMA', N'dbo', 'TABLE', N'sysdiagrams', NULL, NULL
   	end
   	
   	if NOT EXISTS(	select major_id 
   					from sys.extended_properties
   					where major_id = object_id(N'dbo.sp_upgraddiagrams') and class = 1 and minor_id = 0 and name = N'microsoft_database_tools_support')
   	begin
   		exec sp_addextendedproperty N'microsoft_database_tools_support', @val, 'SCHEMA', N'dbo', 'PROCEDURE', N'sp_upgraddiagrams', NULL, NULL
   	end
   
   

   If you set SqlScriptPublishModel.AllowSystemObjects to true when you include the URN in SelectedObjects, does it script the object?