칼럼명 변경및 기타.

ms - sql

1) 칼럼명 변경

Exec sp_rename 'tablename.column name', @newname='column name'

or

Exec sp_rename 'tablename.column name', 'column name'

 

Exec sp_rename 'Page_Table.StartTime', @newname='ST'

 

Oracle)

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

 

2)칼럼 삭제

Alter Table TableName

DROP COLUMN ColumnName

 

3) 칼럼 추가

ALTER TABLE {tableName}

ADD {columnName} {Type} {null|Not null}

CONSTAINT {Constraint_Name} DEFAULT {Default_Value}

or

ALTER TABLE {tableName}

ADD {columnName} {Type} {null|Not null}

Go

ALTER TABLE {tableName}

ADD CONSTRAINT {Constraint_Name} DEFAULT {default value} FOR  {columnName}

ex)

ALTER TABLE Page_Table

ADD StartTime int NOT NULL DEFAULT(1)

 

4) int  -> time

SELECT
CONVERT(VARCHAR,[Column] / 60) + ':' + RIGHT('00' + CONVERT(VARCHAR,[Column] % 60),2)
FROM TableName

or

declare @time int

set @time = 70

 

select  case ((@time / 60) as varchar(2)) + ':' + case ((@time % 60) as varchar(2))