How to copy or migrate database diagrams into another database
We discussed in one of the previous articles called “How to store a SQL Server database diagram into a file…
Archive
Category: T-SQL
How to create a system object (Table, Stored Procedure, View…)
It is really easy. You just need to add the object name as a parameter to “SYS.SP_MS_MARKSYSTEMOBJECT”. In the following…
How to query extended properties
If you are working in a company that your managers are getting database documentation seriously, thumbs up! One of the…
How to create schema dynamically using dynamic SQL
In this short post I’ll show you how to create database schema using dynamic SQL. It’s easy, just take a…