...Technology Simplified

Friday, April 20, 2012

How to create copy of existing database diagram

No comments :
INSERT INTO sysdiagrams   
([name]
,[principal_id]
,[version]
,[definition])
SELECT 'TESTNAME'
,[principal_id]
,[version]
,[definition]
FROM sysdiagrams
where diagram_id = 6

select * from sysdiagrams

No comments :

Post a Comment