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]
|