(This article was originally published at https://www.dbbest.com/blog/ Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For example, we had sp_addindex and sp_dropindex , as well as sp_addtype , sp_droptype , sp_addlogin and sp_droplogin . For Changing certain Database Properties, we had sp_changedbowner and sp_dbcmptlevel, to name a few. Gradually, Microsoft has started replacing these procedures with the more generic DDL commands ADD,...(read more)