Friday, March 9, 2012

List of keys, indexes

Hello,

I am new in SQL Server, I have to deal with this big database with many tables, is there any way I can get a list of all primary keys , foreign keys and indexes and on all tables?

Thanks,

I highly suggest downloading Microsoft'sSQL Server 2000 Books Online. This is a free SQL Server 2000 reference and it is invaluable. You can also access it online:Getting Started with SQL Server Books Online, although it is much easier to work with as a local installation. Check out theInformation Schema Views topic.

No comments:

Post a Comment