Get all the Child Tables up to N level
Get all the dependent tables for a master table up to N level(Till the leaf ) you can either find dependency or you can find all the child tables.
2021-04-14 (first published: 2013-09-04)
3,327 reads
Get all the dependent tables for a master table up to N level(Till the leaf ) you can either find dependency or you can find all the child tables.
2021-04-14 (first published: 2013-09-04)
3,327 reads
This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.
2021-04-14 (first published: 2012-10-17)
1,239 reads
2013-12-26
1,761 reads
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
I need some guidance on choosing data types and lengths for columns in my...
Hi all, First I want to ask just a generic question. Does RLS in...
Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers