My query doesn’t seems to parse information_type STEP TO REPRODUCE: Take AdventureWork or any other test database Right click on your test database > Tasks > Data Discovery and Classification > Classify Data… and classify a bunch of data Now use this query to check your information_type column (here I’m using AdventureWork2019): Paste this select and execute As you can