ITPub博客

_[@more@]在sqlserver中显示表的结构比如现实表TEST1的结构就run sp_showtable 'TEST1'IF OBJECT_ID('dbo.sp_showtable') IS NOT NULLBEGIN DROP PROCEDURE dbo.sp_showtable IF OBJECT_ID('dbo.sp_showtable') IS NOT NULL PRINT '<<< FAILED DROPPING PROCEDURE dbo.sp_showtable >>>' ELSE PRINT '<<< DROPPED PROCEDURE dbo.sp_showtable >>>'ENDgoSET ANSI_NULLS ONgoSET QUOTED_IDENTIFIER ONgocreate procedure [dbo].[sp_showtable] @tablename varchar(50) as begi