Azure sql server check foreign key

select schema_name(fk_tab.schema_id) + '.' + fk_tab.name as foreign_table,
    '>-' as rel,
    schema_name(pk_tab.schema_id) + '.' + pk_tab.name as primary_table,
    substring(column_names, 1, len(column_names)-1) as [fk_columns],
    fk.name as fk_constraint_name
from sys.foreign_keys fk
    inner join sys.tables fk_tab
        on fk_tab.object_id = fk.parent_object_id
    inner join sys.tables pk_tab
        on pk_tab.object_id = fk.referenced_object_id
    cross apply (select col.[name] + ', '
                    from sys.foreign_key_columns fk_c
                        inner join sys.columns col
                            on fk_c.parent_object_id = col.object_id
                            and fk_c.parent_column_id = col.column_id
                    where fk_c.parent_object_id = fk_tab.object_id
                      and fk_c.constraint_object_id = fk.object_id
                            order by col.column_id
                            for xml path ('') ) D (column_names)
order by schema_name(fk_tab.schema_id) + '.' + fk_tab.name,
    schema_name(pk_tab.schema_id) + '.' + pk_tab.name

Source: dataedo.com

Similar codes

0 vote219 views1 answer
Postgresql create table with boolean column
SQL
0 vote205 views2 answers
T SQl Checking Your Username
SQL
23 votes207 views4 answers
How to show all users in mysql
SQL
0 vote203 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
2 votes207 views3 answers
Sql truncate table
SQL
0 vote224 views2 answers
Plpgsql
SQL
0 vote231 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote232 views1 answer
How to check default value of column in sql server
SQL
0 vote262 views1 answer
Updating database in sql
SQL
0 vote195 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL