Stored procedure to give primary key column details of table

Create proc sp_getprimarykeydetails
(@tablename varchar(500))
as
select c.COLUMN_NAME,c.TABLE_NAME,c.DATA_TYPE,
(Case when C.DATA_TYPE  like '%Char%' then CHARACTER_MAXIMUM_LENGTH
when c.DATA_TYPE like '%int%' or c.DATA_TYPE like '%decimal%' then NUMERIC_PRECISION
when c.DATA_TYPE like '%date%' then DATETIME_PRECISION
Else Null End) as Precision,
(Case  when c.DATA_TYPE like '%int%' or c.DATA_TYPE like '%decimal%' then NUMERIC_SCALE
Else Null End) as NumericScale
from sys.objects o
inner join sys.indexes i on i.object_id=o.object_id and is_primary_key=1
inner join information_Schema.key_column_usage kcu on kcu.CONSTRAINT_NAME=i.name
inner join information_Schema.columns c on c.COLUMN_NAME=kcu.COLUMN_NAME and c.TABLE_NAME=o.name
where o.name =@tablename