Hi,

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
tables structure
and indexes using SQL Query Analyzer or using stored procedures.

tq.

On Tue, 26 Apr 2005 21:17:01 -0700, GW wrote:

Hi GW,

Check out the following subjects in Books Online:

* The various INFORMATION_SCHEMA views;
* The stored procedures sp_help, sp_helpindex, and sp_indexes.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)