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.
2015-07-14 (first published: 2015-06-10)
1,748 reads
Miscellaneous
2014-08-06
2,497 reads
2012-10-22
7 reads
2012-10-13
1 reads
2012-10-08
3 reads
2012-09-15
5 reads
Discuss content posted by Kishore Tallapragada
Discussions about content posted by Kishore Tallapragada
2012-09-13
13 reads
2012-08-19
2 reads
2012-08-15
3 reads
2012-08-08
2 reads
Blogs
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
By SQLBalls
Hello Dear Reader! It's been a while since I had time to sit down...
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my...
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Forums
Track Insert/Update/Delete Operations in Sql Server DB Table
Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...
Microsoft SQL over IPSEC VPN TPLink routers - 2 locations
Hi Experts. We recently set up a second location. our software at our first...
Trouble moving from a 2017 SQL Express DB on one HP laptop to another HP laptop
I am trying to migrate a DB from an old dying laptop to a...
Ask SSC