doubt in sql.

if you want to see what type of validations we made
you can use in MSsql server by "sp_help table_name" and execute which will show all columns name ,primary key,foreign key ,is index is made ,whether cluster ,non cluster and on which column .

correct me if i am wrong