DotNetShoutout - CREATE SCHEMA statement must be the only statement in the batch

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

4
Shouts

Shout it

CREATE SCHEMA statement must be the only statement in the batch

published 439 days, 18 hours, 21 minutes ago posted by

dhara 445 days, 7 hours, 34 minutes ago

Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to help my friends in the same boat :) I am creating this tip.

category: Data | clicked: 110 | | source: beyondrelational.com | show counter code

tags: SQL Server

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout