Peter He


Technical Article

Generate script for extended properties

The stored procedure generates insert script for table and column extended properties in the current database. The generated script checks whether a property exists, if it exists, drop it first. The stored procedure assumes table owner is dbo. It can be easily changed to other users.

(1)

You rated this post out of 5. Change rating

2005-11-11 (first published: )

1,954 reads

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

BCA KCU MANGGA DUA RAYA Hub.0853•5504•2311

By greatdubai02

BCA KCU MANGGA DUA RAYA Hub.0853•5504•2311 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok...

ATM Bank BCA A. Yani, Pekanbaru TLP/WA 08216977749

By Call Center Cs BRI QLola

Jl. Jend. Ahmad Yani No.41 C, Kota Baru, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau...

BCA KCP Kas Arifin Ahmad TLP/WA 08216977749

By Call Center Cs BRI QLola

Komp. Hatta Centre, Jl. Arifin Ahmad Perkantoran Soekarno No.9 Blok D, Sidomulyo Timur, Marpoyan...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers