sqlserver 批改表的几个语句

分类: IT文章 • 2024-09-17 11:55:19

sqlserver 修改表的几个语句

ALTER TABLE ddlib.OpacManagement ADD TypeName Varchar(10)

create index JJournalArticlesLibrary_hzyx_1_ArticleID on [dbo].[JournalArticlesLibrary_hzyx_1](ArticleID)

Alter table dbo.JournalArticlesLibrary_hzyx_1 add primary key(ID)

ALTER TABLE ddlib.OpacManagement ADD RecallReminder Varchar(1),ReserveReminder Varchar(1)