Reply to get the DB index SQL

Your name:

Reply:


Posted by dBlue on 11/15/05 21:13

Hi all

is there any efficient way to get the T-SQL statement for an existing
index? In the EM, we can
1) right-click on a tablename -- All Tasks -- Manage Indexes;
2) select an index, then click on "Edit";
3) Click on "Edit SQL"

to get the SQL for the indexes as below

CREATE UNIQUE
INDEX [idxName] ON [dbo].[tblName] ([colName])
WITH
FILLFACTOR = 90
,DROP_EXISTING
ON [PRIMARY]

But, is there any other way; such as the sp_helptext we used for store
procedure, that can automatically generate the SQL (above) for us?

Thanks

Albion(052X)

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация