Schema Only Database Backup

Use DBCC CLONEDATABASE to make a Schema Only Database Backup

Default Schemas

Moving a Default Schema

The Schema Name

Setting a default schema

Moving a Table

Being Careful with Schema Ownership

When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.

Renaming a Schema in SQL Server

If you have a schema you want to retire, here's a method for moving all objects inside that schema to a new one.

Who Changed My Database Schema?

Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.

List schemas in a database

This is an expansion of the sys.schemas table.
User schemas are sorted to the top, schema type is decoded, schema authorization is included.