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

Enjoying SQL Bits

By

It’s been a good week at SQL Bits. This is my favorite conference, and...

Data Tester Diary: Jak jsem úspěšně složila ISQTB certifikaci

By

V Joyful Craftsmen máme skvělý bonus (tzv. SGP), v rámci, kterého se můžeme vzdělávat v...

KQL Series – KQL the next query language you need to learn – a video from Data Exposed

By

I love KQL so much I even made a video and if you compare...

Read the latest Blogs

Forums

Bcp queryout issue

By kakovatos7

Hi all, I am running the following query in SQL, trying to export some...

SQL Server RLS Database Users and Login User Permission

By Irakli Lomidze

Please suggest practice on SQL Server RLS On the database level, defined users with...

SSIS connection manager password update

By vibhuti

Hello, I have 3 SSIS packages having connection manager defined with a userA. These...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers