본문 바로가기
DataBase/MSSQL

[MSSQL] 테이블 형식 확인

by 호호호호히히히히 2018. 3. 13.
728x90
반응형


When you checking column format. 


sp_columns [table Name]


SELECT * FROM information_schema.columns WHERE table_name = '[table Name]'



SQL)

sp_columns [table Name]


Result)




SQL)

SELECT * FROM information_schema.columns WHERE table_name = '[table Name]'


Result)


반응형

댓글