11 lines
609 B
Transact-SQL
11 lines
609 B
Transact-SQL
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; |