ALTER TABLE tb ADD column_b int NULL --看联机帮助if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[存储过程]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[存储过程] --随便点个存储过程,生成SQL脚本就有了。
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[存储过程]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[存储过程]
--看联机帮助if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[存储过程]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[存储过程]
--随便点个存储过程,生成SQL脚本就有了。
drop procedure [dbo].[存储过程]