일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
- import
- Source
- bash
- JavaScript
- port
- GIT
- grep
- ssh
- Mac
- Eclipse
- resource
- Windows 10
- IntelliJ
- context
- 공통표준용어
- find
- netsh
- 단축키
- VirtualBox
- Quartz
- copy-dependencies
- 네트워크
- xargs
- profile
- lsof
- web.xml
- Windows
- maVen
- DB 도메인
- tomcat
- Today
- Total
목록DB/MSSQL (16)
develog
테이블 코멘트 조회 SELECT OBJTYPE, OBJNAME, NAME, VALUE FROM ::FN_LISTEXTENDEDPROPERTY (NULL, 'SCHEMA', 'DBO', 'TABLE', '테이블명', DEFAULT, DEFAULT) ; 컬럼 코멘트 조회 SELECT OBJTYPE, OBJNAME, NAME, VALUE FROM ::FN_LISTEXTENDEDPROPERTY(NULL, 'SCHEMA', 'DBO', 'TABLE', '테이블명', 'COLUMN', DEFAULT) ;
https://msdn.microsoft.com/ko-kr/library/ms174205.aspx
SELECT *FROM SYSOBJECTSWHERE 1=1AND XTYPE = 'U'ORDER BY NAME;
테이블 select * from INFORMATION_SCHEMA.TABLES where table_type = 'BASE TABLE' order by table_name ; 뷰 select * from INFORMATION_SCHEMA.TABLES where table_type = 'VIEW' order by table_name ; 컬럼 select * from INFORMATION_SCHEMA.columns order by table_name, ORDINAL_POSITION ; 프로시저 select * from INFORMATION_SCHEMA.ROUTINES where routine_type = 'PROCEDURE' order by routine_name ; 펑션 select * from INFOR..