bugged.be

"Think outside the [B0X]"
Icon

test if column in table exists

select * from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME=’tablename’
and COLUMN_NAME=’columname’

Category: Sql

Tagged: