Technical Article

Schema View

Here is a simple view that is useful to pull basic data dictionary information out of your DB user tables. The description field is an extended property that I like to use for built in documentation of fields. This only works with 2000, 7 had a slightly different layout for the system tables.

2004-10-27 (first published: )

328 reads

Blogs

Daily Coping 1 Dec 2022

By

Today’s coping tip is to discover your artistic side. Design a friendly greeting card....

New Database Job – The 6 Month Plan

By

So, we made it through our first 90 days, things start getting tougher now...

SQL Homework – December 2022 – What’s new in SQL Server?

By

SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...

Read the latest Blogs

Forums

Replication Statistics

By coolchaitu

In Transactional Replication, create index and Alter index commands do not get replicated to...

KTO CHÂU Á - CHUYÊN TRANG CÁ CƯỢC NHIỀU KHUYẾN MÃI HẤP DẪN!

By wwwlodektocom

KTO Châu Á là một nhánh thuộc KTO Group - công ty hàng đầu...

tậu mai giống ở đâu? Nơi bán phôi mai vàng giá rẻ, bán mai giống TPHCM

By tt140411

tậu mai giống ở đâu? Nơi bán phôi mai vàng giá rẻ, bán mai...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers