DROP INDEX [NCU_Fenntarto_Azonosito] ON [dbo].[T_FENNTARTO];
DROP INDEX [NCU_Fenntarto_Guid] ON [dbo].[T_FENNTARTO];

ALTER TABLE dbo.[T_FENNTARTO] ALTER COLUMN [C_AZONOSITO] NVARCHAR (16) NOT NULL;
ALTER TABLE dbo.[T_FENNTARTO] ALTER COLUMN [C_GUID] UNIQUEIDENTIFIER NOT NULL;

CREATE UNIQUE NONCLUSTERED INDEX [NCU_Fenntarto_Azonosito] ON [dbo].[T_FENNTARTO]([C_AZONOSITO] ASC) WHERE ([TOROLT]='F');
CREATE UNIQUE NONCLUSTERED INDEX [NCU_Fenntarto_Guid] ON [dbo].[T_FENNTARTO]([C_GUID] ASC) WHERE ([TOROLT]='F');

EXEC dev.uspCreateSchemaViews 'T_FENNTARTO';
EXEC dev.sp_Global_GenerateAsyncAuditTriggerAll;