USP_BUSINESSPROCESS_DROPVIEW
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @VIEWNAME | nvarchar(128) | IN |
Definition
Copy
create procedure dbo.[USP_BUSINESSPROCESS_DROPVIEW]
(
@VIEWNAME nvarchar(128)
)
with execute as owner
as
declare @SQL nvarchar(max);
set nocount on;
set @SQL =
'drop view dbo.[' + @VIEWNAME + '];';
exec (@SQL);
return 0;