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: )

540 reads

Blogs

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Top Azure Synapse Analytics and Power BI questions

By

I have listed below the top questions I see from customers about Azure Synapse...

Pre-Conference Workshop and Sessions at PASS Summit

By

I’m pleased to announce that I will be presenting at PASS Summit. This year...

Read the latest Blogs

Forums

Index scan

By hello.priyanka

Hi, I have a query as below: ;With P As (Select ProductID --Query that...

why cannot use ClientProcessID to trace data in SQL Server Profile.

By 892717952

A C/S system is running on a SQL Server database, and I get its...

Copying an Azure SQL Database with PowerShell

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Copying an Azure SQL Database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers