>>>Hi
>>>
>>>EXEC sp_pkeys @table_name = tableName
>>>
>>>
>>
>>Is it the only way? I want to create a query, how would I use this sp in a query? I'm not on a computer with SQL Server, can't test at the moment.
>
>As far as i know
>Insert data returned by sp_pkeys in #temp and use in you query.

Here is the code that worked for me

select tc1.PK_Field, col.Table_Name, col.Column_Name, col.Data_Type, col.Character_Maximum_Length 
from INFORMATION_SCHEMA.COLUMNS col 
INNER JOIN INFORMATION_SCHEMA.TABLES tab on col.Table_Name = tab.Table_Name 
LEFT JOIN (SELECT ccu.Column_Name as PK_Field, tc.Table_Name from 
INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc 
	INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
		ON tc.CONSTRAINT_name = ccu.CONSTRAINT_name 
WHERE CONSTRAINT_type = 'PRIMARY KEY') tc1 ON col.Table_Name = tc1.Table_Name 
WHERE tab.Table_Type = 'BASE TABLE' AND col.Character_Maximum_Length >=100 order by 2,3

Thanks again for your help.