9-03.sql

sql2000工程实践一书第9张源代码

USE pubs
IF EXISTS (SELECT name FROM sysobjects 
         WHERE name = 'showind2' AND type = 'P')
   DROP PROCEDURE showind2
GO
CREATE PROC showind2 @table varchar(30) = 'titles'
AS 
SELECT TABLE_NAME = sysobjects.name,
INDEX_NAME = sysindexes.name, INDEX_ID = indid
FROM sysindexes INNER JOIN sysobjects ON sysobjects.id = sysindexes.id
WHERE sysobjects.name = @table
GO