Gather Meta Data

Hi,

I would like to prepare a data dictionary for my database (northwind).

I have framed the below SQL

SELECT
'NAME ' = a.name,
'DESCRIPTION' = b.value,
'Type ' = type_name(a.xusertype),
' ' AS 'Values',
'NULL ' = case when a.isnullable = 0 then ' ' else 'X' end,
' ' AS 'PK',
' ' AS 'FK'
FROM
syscolumns a,
sysproperties b

WHERE
a.id = 2073058421 AND --- Customers Table
a.number = 0 AND
b.id = a.id AND
b.smallid = a.colid

ORDER BY a.colid

and the output would be:

NAME DESCRIPTION Type Values NULL PK FK
-------------- --------------- ---------- ------ ----- ---- ----
CustomerID Customer ID nchar
CompanyName Company Name nvarchar
ContactName Contact Name nvarchar X
ContactTitle Contact Title nvarchar X
Address Address nvarchar X
City City nvarchar X
Region Region nvarchar X
PostalCode Postal Code nvarchar X
Country Country nvarchar X
Phone Phone # nvarchar X
Fax Fax # nvarchar X



PK and FK is where I need to print whether the column is Primary Key or
Foreign Key.

If CustomerId is defined as Primary Key then PK should have X printed.
Thats the objective.

How will I accomplish this ?


Thanks in advance,
Anu