<< 鐃緒申鐃緒申牢鐃獣縁申鐃�DirectX | main | SQLServer NTEXT >>

2006.08.22 Tuesday | 14:09

  SQLServer default 鐃緒申鐃緒申 鐃緒申録

鐃緒申鐃緒申鐃宿駕申
( 鐃緒申鐃緒申鐃緒申媛短鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃叔は￥申鐃緒申鐃緒申名鐃熟種申動鐃緒申鐃緒申 )

ALTER TABLE [鐃銃￥申鐃瞬ワ申名]
ADD CONSTRAINT [鐃緒申鐃緒申名]
DEFAULT 鐃緒申 FOR [鐃緒申名]


鐃緒申鐃緒申表鐃緒申

SELECT 
	(select text from syscomments where id = sys2.id) as default_value
	,sys1.name,sys1.crdate,sys2.name
 from
   sysobjects as sys1 INNER JOIN sysobjects as sys2
 on sys1.id = sys2.parent_obj
 where
   sys1.xtype = 'U' and sys2.xtype = 'D' 
 order by
   sys1.name


鐃緒申鐃緒申鐃緒申

alter table [鐃銃￥申鐃瞬ワ申名]
drop constraint [鐃緒申鐃緒申名]


鐃緒申鐃緒申任鐃緒申鐃緒申鐃�

1) 鐃緒申鐃緒申諭鐃�
2) 鐃舜随申鐃緒申
3) SQL-92 鐃祝ワ申妊鐃緒申奪鐃緒申愎鐃�
4) NULL

鐃緒申鐃祝ワ申妊鐃緒申奪鐃緒申愎鐃�
CURRENT_TIMESTAMP 鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒申
CURRENT_USER 鐃緒申鐃緒申鐃緒申孫圓鐃緒申討鐃緒申鐃醇ー鐃緒申鐃緒申鐃緒申名鐃緒申
SESSION_USER 鐃緒申鐃緒申鐃緒申孫圓鐃緒申討鐃緒申鐃醇ー鐃緒申鐃緒申鐃緒申名鐃緒申
SYSTEM_USER 鐃緒申鐃緒申鐃緒申孫圓鐃緒申討鐃緒申鐃醇ー鐃緒申鐃緒申鐃緒申名鐃緒申
USER 鐃緒申鐃緒申鐃緒申孫圓鐃緒申討鐃緒申鐃醇ー鐃緒申鐃緒申鐃緒申名鐃緒申

CURRENT_TIMESTAMP 鐃緒申 getdate() 鐃緒申同鐃緒申


lightbox   Category: 鐃緒申録