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

326 reads

Blogs

Hello world!

By

Welcome to WordPress. This is your first post. Edit or delete it, then start...

Daily Coping 2 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2021 – Changing collation

By

I can only speak for the locations I’ve worked at of course, but in...

Read the latest Blogs

Forums

SQL Query Help on Time based query

By dcw8888

I have a following table (Contains script to generate the sample table with data):...

When to Use a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When to Use a Database

SQL Server Data Masking: a comparison with Gallium Data

By maxtardiveau

Comments posted to this topic are about the item SQL Server Data Masking: a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers