SQL Server: how to determine a column algorithm encryption I have a table with a column, Column_Password, where I can see the password encrypted. 

How can I know what type of algorithm encryption the column is using? How can I find if it's sha1, MD5, sha256 or whatever? 

My goal is to check if the password is present in this massive database
You can use sys.columns system catalog view.

Details here:

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-columns-transact-sql