Inspired by whatsabyte.com

Tag: MOC20762

Browse: Wetory / MOC20762

Get constraints with definitions

Scripts June 23, 2020June 23, 2020 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

List all constraints created in database tables including their definition. Very quick overview of data integrity helpers called constraints. HINT: Add where clause to focus on particular tables only....

Query partitions with boundaries

Scripts June 21, 2020 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Check what partitions are you using in the database. Super-useful script to quickly list all partitioned tables with information about file groups, partition schemas and partition functions. HINT: Add where clause...

Byte converter calculator