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

322 reads

Blogs

The Azure-SSIS IR Startup Time

By

If you want to run SSIS packages in Azure Data Factory, you need the...

What is a container anyway?

By

Recently there was a thread on Twitter which established that a lot of IT...

Comparing Execution Plans

By

When you run a query twice, and get dramatically different run times, your first...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Sandbox Server - Setting up AGs with 3rd party TDE/KMS

By Brandie Tarvin

Mandate coming down from corporate is that we need to start encrypting our databases....

Row and Column wise Total in pivot table

By akhterhussain80

I want row wise and column wise Total   Create table #Sections (SecID int,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers