2
I need a query that brings the name of the columns in a table that accept boolean. Ex: In the table clientes, have the fields casapropria (1 for yes, 0 for no), temfilhos (1 for yes, 0 for no).
2 answers
2
SELECT column_name FROM information_schema.columns
WHERE table_name = 'clientes' AND data_type = 'bit'
1
People,
Eventually I did. Follow if you are useful
Browser other questions tagged sql sql-server
You are not signed in. Login or sign up in order to post.
Take a look at [tour]. You can accept an answer if it solved your problem. You can vote on every post on the site as well. Did any help you more? You need something to be improved?
– Maniero