Created
February 20, 2019 13:45
-
-
Save FelipeGangrel/86d0f497e46be475f681591ba24fb014 to your computer and use it in GitHub Desktop.
SIVIS | TICKET4YOU | SQLServer
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** Adicionando campo obrigatorio_credenciamento à sf_eventos */ | |
ALTER TABLE [dbo].[sf_eventos] ADD obrigatorio_credenciamento TINYINT NOT NULL DEFAULT 0; | |
GO | |
EXEC sys.sp_addextendedproperty | |
@name=N'MS_Description', @value=N'0 => não permite credenciamento, 1 => credenciamento opcional, 2 => credenciamento obrigatório', | |
@level0type=N'SCHEMA', @level0name=N'dbo', | |
@level1type=N'TABLE', @level1name=N'sf_eventos', | |
@level2type=N'COLUMN', @level2name=N'obrigatorio_credenciamento' | |
GO | |
/** ========================================================= */ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment