1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
USE [Highlander03(CoursesHippiques)]
;
SELECT 'colonnes', *
FROM INFORMATION_SCHEMA.COLUMNS
order by table_name, ordinal_position
;
SELECT 'tables', *
FROM INFORMATION_SCHEMA.TABLES
order by table_name
;
SELECT 'table constraints', table_name, constraint_name, constraint_type,is_deferrable, initially_deferred
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
order by table_name, constraint_name
;
SELECT 'keys', constraint_name, table_name, column_name, ordinal_position
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
order by table_name, constraint_name, ordinal_position
;
SELECT 'ref constraints', e.table_name as Enfant, p.table_name as Parent, f.constraint_name, f.unique_constraint_name, f.match_option, f.update_rule, f.delete_rule
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS as f
, INFORMATION_SCHEMA.KEY_COLUMN_USAGE as e
, INFORMATION_SCHEMA.KEY_COLUMN_USAGE as p
WHERE f.constraint_name = e.constraint_name
AND f.unique_constraint_name = p.constraint_name
; |
Partager