Normalization

SQL 2005 - List Primary Key Columns

by Sandeep Saretha

SQLServerCentral.com

Normalization

Script

Will list Table Name, Constraint name and Primary Key Column Name.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.2 (5)

Log in or register to rate

You rated this post out of 5. Change rating

2012-06-29 (first published: 2008-03-20)

2,473 reads

Discuss

Blogs

T-SQL Tuesday #185: Video

By Mala Mahadevan

This month’s invite is from Erik Darling, who invites you to make a video...

T-SQL Tuesday #185–Being a Video Star

This month we have an interesting invite. Erik Darling is the host, and since...

Building Resilience: Leadership Insights from Sports

In the bustling world of sports, leadership appears as a beacon of hope and...

Read the latest Blogs

Forums

Part-Time DBAs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Part-Time DBAs

The Long String

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Long String

Level 5 of the Stairway to Synapse Analytics: create and use Delta Lake - Part 2

By Sucharita Das

Comments posted to this topic are about the item Level 5 of the Stairway...

Visit the forum

Question of the Day

The Long String

I have a table (dbo.beer) with this data:

BeerID	BeerName	brewer	beerdescription
-----------	--------------------	--------------------	----------------------------------------------------------------------------------
1	Becks	Interbrew	Beck's is a German-style pilsner beer known for its golden color, full-bodied taste, and a crisp, clean finish with floral and fruity hop aromas, brewed according to the German purity law
2	Fat Tire	New Belgium	Toasty malt, gentle sweetness, flash of fresh hop bitterness. The malt and hops are perfectly balanced.
3	Mac n Jacks	Mac & Jack's Brewery	This beer erupts with a floral, hoppy taste, followed by a well rounded malty middle, finishing with a nicely organic hop flavor. Locally sourced two row grain and a blend of specialty malts give our amber its rich taste.
4	Alaskan Amber	Alaskan Brewing	Alaskan Brewing Amber Ale is an "alt" style beer, meaning it's fermented slowly and at colder temperatures, resulting in a well-balanced, richly malty, and long-lasting flavor profile with a clean, pleasing aftertaste.
8	Kirin	Kirin Brewing	Kirin Ichiban is a Lager-type beer, which means it is fermented at low temperatures and offers a light and refreshing texture with a smooth and balanced flavor.

Here is the DDL For the table:

CREATE TABLE [dbo].[Beer]
(
[BeerID] [int] NOT NULL IDENTITY(1, 1),
[BeerName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[brewer] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[beerdescription] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

I run this code:

SET TEXTSIZE 20;
SELECT
  b2.BeerName
, b2.beerdescription
FROM dbo.Beer AS b2;
GO

What is returned?

See possible answers