Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement