Date: 10/24/06 (SQL Server)    Keywords: database, sql

Hi all, forgive me if these have already been asked a zillion times...

1. what is the SQL query for determining the primary key of a table? meaning, i know there is SOMEthing like this that I can do:

select primary_keys from information_schema where table_name = 'myTable'

...but I don't remember the right syntax. anyone?

2. i'm building my database on a destkop machine. later, i want to do an export that will INCLUDE a very complicated database diagram that i've drawn in Enterprise Manager. is that possible? is there a way to save out JUST the diagram in some format that can later be imported into antoher SQL server machine elsewhere?

thanks for your time.

Source: http://community.livejournal.com/sqlserver/53307.html