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)

• Next in forum: Optimal search for the nearest date
• Prev in forum: NEWID()
• Thread view: get the DB index SQL

[Reply to this message]