SELECT st.name as 'Naziv tabele', skc.type as 'Tip ogranicenja', skc.name as 'Naziv ogranicenja', convert(varchar,skc.create_date, 104) as 'Datum kreiranja'
from sys.tables st left join sys.key_constraints skc on (skc.parent_object_id = st.object_id)
where st.schema_id = (select ss.schema_id from sys.schemas ss where ss.name = 'Ovde ide ime sheme');