Files
C2P/C2P_Project/ext/Tables/ext.RcdClass01.sql
Samuele E. Locatelli 76452aa4dd Refresh Progetto DB
2014-10-21 16:42:06 +02:00

15 lines
742 B
Transact-SQL

CREATE TABLE [ext].[RcdClass01] (
[CodClass01] NVARCHAR (50) NOT NULL,
[CodClass01Rcd] NVARCHAR (50) CONSTRAINT [DF_RcdClass_CodClassRcd] DEFAULT ('') NOT NULL,
CONSTRAINT [PK_RcdClass] PRIMARY KEY CLUSTERED ([CodClass01] ASC)
);
GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'codice cliente', @level0type = N'SCHEMA', @level0name = N'ext', @level1type = N'TABLE', @level1name = N'RcdClass01', @level2type = N'COLUMN', @level2name = N'CodClass01Rcd';
GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'codice cliente', @level0type = N'SCHEMA', @level0name = N'ext', @level1type = N'TABLE', @level1name = N'RcdClass01', @level2type = N'COLUMN', @level2name = N'CodClass01';