VIEWING A TABLES STRUCTURE AND INDEXES - 04-26-2005 , 11:17 PM
I would appreciate it if someone could help me on the following:
I have several tables eg, tbl1, tbl2, tbl3.....tbl10. How to view all the
and indexes using SQL Query Analyzer or using stored procedures.
Re: VIEWING A TABLES STRUCTURE AND INDEXES - 04-27-2005 , 03:40 PM
On Tue, 26 Apr 2005 21:17:01 -0700, GW wrote:
Check out the following subjects in Books Online:
* The various INFORMATION_SCHEMA views;
* The stored procedures sp_help, sp_helpindex, and sp_indexes.
(Remove _NO_ and _SPAM_ to get my e-mail address)