Создание расширеных свойств на таблице sql server
Пример создания расширенных свойств для таблицы на sql server.
USE [DB_NAME]; GO SET ANSI_NULLS ON; GO SET QUOTED_IDENTIFIER ON; GO CREATE TABLE [dbo].[ProductFragmentationHistory] ([Id] [INT] IDENTITY(1, 1) NOT NULL, [ProductFragmentationId] [INT] NOT NULL, [ProductId] INT NOT NULL, [ParentId] INT NOT NULL, [Created] DATETIME NOT NULL, [UserId] INT NULL, [Archived] [DATETIME] NOT NULL, CONSTRAINT [PK_ProductFragmentationHISTORY] PRIMARY KEY CLUSTERED([Id] ASC) ) GO IF NOT EXISTS ( SELECT NULL FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductFragmentationHistory]') AND type IN(N'U') ) BEGIN CREATE TABLE [dbo].[ProductFragmentationHistory] ([Id] [INT] IDENTITY(1, 1) NOT NULL, [ProductFragmentationId] [INT] NOT NULL, [ProductId] INT NOT NULL, [ParentId] INT NOT NULL, [Created] DATETIME NOT NULL, [UserId] INT NULL, [Archived] [DATETIME] NOT NULL, CONSTRAINT [PK_ProductFragmentationHISTORY] PRIMARY KEY CLUSTERED([Id] ASC) ) END; GO IF NOT EXISTS ( SELECT NULL FROM sys.all_columns c JOIN sys.tables t ON t.object_id = c.object_id JOIN sys.schemas s ON s.schema_id = t.schema_id JOIN sys.default_constraints d ON c.default_object_id = d.object_id WHERE t.name = 'ProductFragmentationHistory' AND c.name = 'Archived' AND s.name = 'dbo' ) BEGIN ALTER TABLE [dbo].[ProductFragmentationHistory] ADD CONSTRAINT [DF_ProductFRAGMENTATIONHISTORY_ARCHIVED] DEFAULT(GETDATE()) FOR [Archived]; END; GO IF NOT EXISTS ( SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('dbo.ProductFragmentationHistory') AND [name] = N'MS_Description' AND [minor_id] = ( SELECT [column_id] FROM SYS.COLUMNS WHERE [name] = 'Id' AND [object_id] = OBJECT_ID('dbo.ProductFragmentationHistory') ) ) EXECUTE sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Уникальный идентификатор', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'ProductFragmentationHistory', @level2type = N'COLUMN', @level2name = N'Id'; GO IF NOT EXISTS ( SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('ProductFragmentationHistory') AND [name] = N'MS_Description' AND [minor_id] = ( SELECT [column_id] FROM SYS.COLUMNS WHERE [name] = 'ProductFragmentationId' AND [object_id] = OBJECT_ID('dbo.ProductFragmentationHistory') ) ) EXECUTE sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Уникальный идентификатор связи фрагментированного Product ', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'ProductFragmentationHistory', @level2type = N'COLUMN', @level2name = N'ProductFragmentationId'; GO IF NOT EXISTS ( SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('dbo.ProductFragmentationHistory') AND [name] = N'MS_Description' AND [minor_id] = ( SELECT [column_id] FROM SYS.COLUMNS WHERE [name] = 'ProductId' AND [object_id] = OBJECT_ID('dbo.ProductFragmentationHistory') ) ) EXECUTE sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Идентификатор фрагментированного Product', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'ProductFragmentationHistory', @level2type = N'COLUMN', @level2name = N'ProductId'; GO IF NOT EXISTS ( SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('dbo.ProductFragmentationHistory') AND [name] = N'MS_Description' AND [minor_id] = ( SELECT [column_id] FROM SYS.COLUMNS WHERE [name] = 'ParentID' AND [object_id] = OBJECT_ID('dbo.ProductFragmentationHistory') ) ) EXECUTE sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Идентификатор родителя фрагментированного Product', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'ProductFragmentationHistory', @level2type = N'COLUMN', @level2name = N'ParentId'; GO IF NOT EXISTS ( SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('dbo.ProductFragmentationHistory') AND [name] = N'MS_Description' AND [minor_id] = ( SELECT [column_id] FROM SYS.COLUMNS WHERE [name] = 'Created' AND [object_id] = OBJECT_ID('dbo.ProductFragmentationHistory') ) ) EXECUTE sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Дата создания фрагментированного Product', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'ProductFragmentationHistory', @level2type = N'COLUMN', @level2name = N'Created'; GO IF NOT EXISTS ( SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('dbo.ProductFragmentationHistory') AND [name] = N'MS_Description' AND [minor_id] = ( SELECT [column_id] FROM SYS.COLUMNS WHERE [name] = 'UserId' AND [object_id] = OBJECT_ID('dbo.ProductFragmentationHistory') ) ) EXECUTE sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Идентификатор пользователя создавшего фрагментацию Product', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'ProductFragmentationHistory', @level2type = N'COLUMN', @level2name = N'UserID'; GO IF NOT EXISTS ( SELECT NULL FROM SYS.EXTENDED_PROPERTIES WHERE [major_id] = OBJECT_ID('ProductFragmentationHistory') AND [name] = N'MS_Description' AND [minor_id] = 0 ) EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Таблица связей фрагментированных Product', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'ProductFragmentationHistory'; GO
82 комментарии
-
-
написал online Комментировать
Im obliged for the article. Thanks Again. Keep writing. Inga Baxy Bruckner
Среда, 10 февраля 2021 05:40 -
написал watch Комментировать
Hello to all, how is the whole thing, I think every one is getting more from this website, and your views are good for new viewers. Kit Barn Byrdie
Среда, 10 февраля 2021 05:29 -
написал 720p Комментировать
Valuable info. Lucky me I found your website by accident, and I am shocked why this accident did not happened earlier! I bookmarked it. Lynnelle Rick Cumings
Суббота, 30 января 2021 03:16 -
написал 720p Комментировать
Hello. This post was really remarkable, particularly since I was investigating for thoughts on this matter last Tuesday. Phyllis Hugo Delora
Суббота, 30 января 2021 03:11 -
написал dublaj Комментировать
Good day! I just want to offer you a big thumbs up for the great information you have here on this post. I am returning to your site for more soon. Lari Panchito Kauffman
Суббота, 30 января 2021 02:54 -
написал yabanci Комментировать
These are genuinely wonderful ideas in about blogging. You have touched some pleasant points here. Any way keep up wrinting. Klarrisa Cazzie Feinberg
Суббота, 30 января 2021 02:49 -
написал yabanci Комментировать
Way cool! Some extremely valid points! I appreciate you writing this write-up along with the rest of the site is really good. Robinette Jonas Joaquin
Суббота, 30 января 2021 02:30 -
написал filmkovasi Комментировать
Beautifully written! Thank you for sharing your inspiring words and heartfelt insight. Darell Terrence Virgy
Суббота, 30 января 2021 02:25 -
написал yabanci Комментировать
Simply wanna remark that you have a very decent internet site , I the style and design it really stands out. Melany Worthy Adamson
Суббота, 30 января 2021 02:21
Оставить комментарий
Убедитесь, что Вы ввели всю требуемую информацию, в поля, помеченные звёздочкой (*). HTML код не допустим.
tadalafil price - tadalafil generic tadalafil dosage
Вторник, 02 марта 2021 01:37