0

I need to find boolean column in my DB. I already know how to get data from all my tables:

DECLARE @sqlText VARCHAR(MAX)
SET @sqlText = ''
SELECT @sqlText = @sqlText + ' SELECT * FROM ' + QUOTENAME(name) + CHAR(13) FROM sys.tables
EXEC(@sqlText)

How to display only columns that were declared as boolean (bool)?

Tal Angel
  • 1,301
  • 3
  • 29
  • 63

1 Answers1

1

There is no Boolean data type in SQL Server. See this question.

iDevlop
  • 24,841
  • 11
  • 90
  • 149