Edit D:\SQL20160530-20170910\17.03.08.30_0002_Pub_Album_Add.sql
if (not exists (select name from syscolumns where id = object_id('Pub_Album') and name = 'GradeGuid')) Begin ALTER TABLE Pub_Album ADD GradeGuid nvarchar(64) EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:selectbox fk_table:Pub_Grade fk_key:Guid fk_name:Name ' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_Album', @level2type=N'COLUMN', @level2name=N'GradeGuid' End if (not exists (select name from syscolumns where id = object_id('Pub_Album') and name = 'CategoryGuid')) Begin ALTER TABLE Pub_Album ADD CategoryGuid nvarchar(64) EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:selectbox fk_table:Pub_Category fk_key:Guid fk_name:Name' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_Album', @level2type=N'COLUMN', @level2name=N'CategoryGuid' End if (not exists (select name from syscolumns where id = object_id('Pub_Album') and name = 'AlbumYear')) Begin ALTER TABLE Pub_Album ADD AlbumYear int EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'???? type:text regex:num1 regex_msg:????????' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'Pub_Album', @level2type=N'COLUMN', @level2name=N'AlbumYear' End
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de