get rich schema details of all or some tables

to get information about tables+columns+primarykeys+foreignkeys+identity, i firstly used SQL server built-in INFORMATION_SCHEMA.xxx. however, my company have various DBAs and each of them owns objects. when using INFORMATION_SCHEMA.xxx, it retrieves data based on current login (version 2005 resolves this schema v.s. object owner problem already... yeah) , which bring me a great trouble. if you want […]

3 (2)

2006-08-30 (first published: )

536 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

how to list index corresponding to statistics using select statement

By ebooklub

Hi , with query bellow I  can list DTA  statistic that is not updated...

Get files based on SQL results

By Jay@Work

I have a sql task which queries a database and returns a result set...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers