Создание расширеных свойств на таблице 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 комментарии
-
-
написал full hd izle Комментировать
Testing the applications and articulating for bugs can in like way make transport loads and costs alike. Sharai Demetre Medardas
Среда, 13 января 2021 20:32 -
написал full hd izle Комментировать
Excellent site. Plenty of useful information here. Gayle Boycie Penrose
Среда, 13 января 2021 20:26 -
написал 720p Комментировать
Thanks so much for the blog article. Really looking forward to read more. Keep writing. Dennie Andrew Trask
Среда, 09 декабря 2020 07:20 -
написал 720p Комментировать
Im thankful for the article post. Really thank you! Want more. Phedra Hobie Dulcy
Среда, 09 декабря 2020 07:16 -
написал 720p Комментировать
This article offers clear idea in favor of the new visitors of blogging, that actually how to do blogging. Ilise Etienne Kath
Среда, 09 декабря 2020 07:14 -
написал 720p Комментировать
If you desire to improve your familiarity only keep visiting this web page and be updated with the hottest news posted here. Regine Sullivan Yaakov
Среда, 09 декабря 2020 01:26 -
написал 720p Комментировать
Helpful info. Lucky me I discovered your website by accident, and I am stunned why this coincidence did not came about in advance! I bookmarked it. Fredericka Gael Wilkey
Среда, 09 декабря 2020 01:22 -
написал erotik film izle Комментировать
Wow! At last I got a webpage from where I be able to really take valuable facts concerning my study and knowledge. Sonny Titus Kerry
Вторник, 08 декабря 2020 17:40 -
написал sikis izle Комментировать
Hello. This article was really fascinating, particularly because I was browsing for thoughts on this issue last week. Datha Oswald Arda
Вторник, 08 декабря 2020 17:37
Оставить комментарий
Убедитесь, что Вы ввели всю требуемую информацию, в поля, помеченные звёздочкой (*). HTML код не допустим.
What a data of un-ambiguity and preserveness of precious familiarity concerning unpredicted feelings. Ruthann Lanie Corby
Четверг, 21 января 2021 16:36