9-03.sql

来自「sql2000工程实践一书第9张源代码」· SQL 代码 · 共 13 行

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