sql Archives - Page 2 of 3

ms sql 데이타베이스 복원방법

출처 : http://nextstep.co.kr/105

— 백업생성(있으면 생략)

BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'

1 2	BACKUP DATABASE Northwind TO DISK = 'c:\Northwind.bak'

–백업정보확인(논리적파일명, 물리적저장위치및파일명 확인)

RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'

1 2	RESTORE FILELISTONLY FROM DISK = 'c:\Northwind.bak'

— TestDB라는 새로운 데이터베이스로 새로운 경로(C:\temptest*.*)으로 복원

RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\testtestdb.mdf',
MOVE 'Northwind_log' TO 'c:\testtestdb.ldf'

RESTORE DATABASE TestDB

FROM DISK = 'c:\Northwind.bak'

WITH MOVE 'Northwind' TO 'c:\testtestdb.mdf',

MOVE 'Northwind_log' TO 'c:\testtestdb.ldf'

[출처] MSSQL 테이블명 , 컬럼명 바꾸기|작성자 zino1187

1.테이블명 바꾸기

sp_rename OldTable , NewTable

1	sp_rename OldTable , NewTable

2.컬럼명 바꾸기

sp_rename 'TableName.OldColumn','TableName.NewColumn'

1	sp_rename 'TableName.OldColumn','TableName.NewColumn'

[출처] mssql alter table column작성자 재원맨

1. 테이블 필드 수정하기

alter table sale alter column title varchar(200) not null

1	alter table sale alter column title varchar(200) not null

2. 필드 삭제하기

alter table sale drop title

1	alter table sale drop title

3. 필드 추가하기

alter table sal add sale varchar(20) not null
alter table sale add isDel bit DEFAULT 0 not null

1 2	alter table sal add sale varchar(20) not null alter table sale add isDel bit DEFAULT 0 not null

select *
from dba_tab_comments
where 1=1
and owner='anyxxxxxx'
and comments is NULL
and table_name not like 'BIN$%'
order by table_name

select *

from dba_tab_comments

where 1=1

and owner='anyxxxxxx'

and comments is NULL

and table_name not like 'BIN$%'

order by table_name