select c.name as name,t.name as type ,convert(bit,c.IsNullable) as isNULL , from sysobjects where xtype='PK' and parent_obj=c.id and name in ( select name from sysindexes where indid in( end) as isKey ,convert(bit,COLUMNPROPERTY(c.id,c.name,'IsIdenti