How to findout if the column is Unique or Key?

---

I use sp_columns to retrieve colum information of a table.
But, it doesn't return the columns' index information such as Key or Unique..

How can I get these info along with those from sp_columns?

You want to take a look at sp_helpindex, sp_pkeys, sp_foreignkey stored procedures. Also, you want to take a look at info views (i.e. information_schema.*).

How to find out free space on a server ?any Script for this?

HI ,
I have a problem ,i am using solaries OS..,and i need to know how to
findout free space on a server ,which includes several databases .
Thanks
Suresh .I assume you didn't mean to find some sort of free space on Solaris.
Anyway, it would help if you can be more spcific on what free space you were
referring to. Free space in a database, or free space on a given drive on the
server, etc?
Linchi
"kamma.venkatasuresh@.gmail.com" wrote:
> HI ,
> I have a problem ,i am using solaries OS..,and i need to know how to
> findout free space on a server ,which includes several databases .
> Thanks
> Suresh .
>