Hi!
I need to pull out some metada from database. From every table I want to pull out relations so PK and FK. But I want to have it in form that I will exactly now that FooId is PK in Foo table nad FooBarId is foreign key from FooBar table and so on. And I need it for specified tables.
It can be done by one or more queries for every table so it doesn't have to be one big select. I just need to know how to get this data ;)
TIA
Jarod
you can use SSMS to generate script for all your objects in your database.
Steps:
(1) go to object explorer
(2) select the databse
(3) right click and choose tasks and then choose the subtask 'Generate Scripts....
(4) This wizard will walk you thru the script generation
No comments:
Post a Comment