two questions
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.
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.
