Joan Magnet

List all the fields of a table with its properties + PK

This script returns a list of all the fields of a table with it properties, primary keys and user defined types.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2020-01-21 (first published: 2014-04-30)

1,719 reads

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

I had an idea for an animated view of a sales tool, and started...

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Think there's a reason why this is still in preview, but have someone manage...

Comments posted to this topic are about the item SQL Server 2025 Query Performance...

This is a generic question. To the moderators, I wasn't sure where to place...

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO