22 lines
486 B
Transact-SQL
22 lines
486 B
Transact-SQL
DROP PROCEDURE IF EXISTS sp_ElozoTanevesViewokTorlese
|
|
GO
|
|
|
|
CREATE PROCEDURE sp_ElozoTanevesViewokTorlese
|
|
@pintezmenyId INT
|
|
,@pintezmenyAzonosito NVARCHAR(MAX)
|
|
,@pkovTanevId INT
|
|
WITH EXECUTE AS 'kreta_tech_user'
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON
|
|
|
|
DECLARE @schemaName nvarchar(max) = CONCAT(N'KR_', @pintezmenyAzonosito, N'_Schema')
|
|
|
|
EXEC dev.uspDeleteViewsAll @schemaName
|
|
EXEC dev.uspCreateSchemaViews
|
|
@pTables = NULL
|
|
,@pSchemas = @schemaName
|
|
,@pDebugMode = 0
|
|
END
|
|
GO
|