MSSQL Archives - Page 2 of 4

MSSQL Table List Query

(10%) select name from sysobjects where type='U'
(13%) select * from information_schema.tables
(76%) select * from sys.tables

(10%) select name from sysobjects where type='U'

(13%) select * from information_schema.tables

(76%) select * from sys.tables

[한글컬럼값 들어있는 것만 지우기]

select *  from tbl where field like '%[가-힣]%'
delete  from tbl where field like '%[가-힣]%'

1 2	select * from tbl where field like '%[가-힣]%' delete from tbl where field like '%[가-힣]%'

[영문컬럼값 들어있는 것만 지우기]

select * from tbl where field like '%[A-Za-z]%'
delete from tbl where field like '%[A-Za-z]%'

1 2	select * from tbl where field like '%[A-Za-z]%' delete from tbl where field like '%[A-Za-z]%'