Hi,

In SQL Server table, which datatype we can use for password char (*), even if the user have read permission to see the table information, they can see * char only.

That does not exist for SQL Server. If you are storing passwords, you must first hash or encrypt them. Do a Google search.