인문정보데이터베이스20201022

• 이름 바꾸기

 use class2020
 select * from sys.tables
 select * from jdcDomainNode
 update jdcDomainNode set label=N'강녕전(康寧殿)' where id='강녕전'
 select * from jdcDomainNode
 where label like'%(%)'

• table 만들기

create table jdcDomainNode(
id nvarchar(40) not NUll,  
class nvarchar(40)  NUll,
groupName nvarchar(40) NUll, 
partName nvarchar(40)  NUll,
label nvarchar(80) NUll, 
infoUrl nvarchar(256) NUll,
iconUrl nvarchar(256) NUll,
note nvarchar(256) NUll
primary key(id)

)