"i Born 2 Code" is a virtual place to present some technical, technological, informative news, daily photos, and interesting information in computer, programming, technology, art! and or may be in weird fields! Tons of information all around makes the job difficult to present the best ones, anyway It will try to be cool and informative. Then let's go.
Unlike stored procedure, functions, tables, views, ... MS Sql server doesn't have an easy way to script or create database diagrams. It keeps all the diagrams in [sysdiagrams] system table.
SELECT * FROM sysdiagrams
USE newDb GO
INSERT INTO sysdiagrams ([name], pricipal_id, version, definition) SELECT [name], pricipal_id, version, definition FROM #tempDiagrams
No comments:
Post a Comment