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

537 reads

Blogs

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

My home office setup

By

That aging hippie (he likes Apple products and has a goatee) known as Brent...

Read the latest Blogs

Forums

Switching Database context in transaction

By Thomas Franz

Comments posted to this topic are about the item Switching Database context in transaction

Stable Marriages Using SQL Server

By Glen Cooper

Comments posted to this topic are about the item Stable Marriages Using SQL Server

Cranky Curmudgeons

By Grant Fritchey

Comments posted to this topic are about the item Cranky Curmudgeons

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers