/SQL/How to see table associated with a schema in sql

How to see table associated with a schema in sql

select s.name as schema_name, 
    s.schema_id,
    u.name as schema_owner
from sys.schemas s
    inner join sys.sysusers u
        on u.uid = s.principal_id
order by s.name

Source: dataedo.com

How to see table associated with a schema in sql

select schema_name(t.schema_id) as schema_name,
       t.name as table_name,
       t.create_date,
       t.modify_date
from sys.tables t
where schema_name(t.schema_id) = 'Production' -- put schema name here
order by table_name;

Source: dataedo.com

Similar codes

0 vote147 views1 answer
Drop domain postgresql
SQL
0 vote134 views1 answer
Prisma transaction
SQL
0 vote110 views1 answer
Sql server count all tables rows
SQL
2 votes119 views5 answers
Eloquest how to select one specific column in database
SQL
2 votes109 views3 answers
Current month mysql query
SQL
0 vote117 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote70 views2 answers
Spring properties file for db
SQL
0 vote111 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote103 views2 answers
Mysql order by date asc null last
SQL
1 vote101 views1 answer
Rename table column name in mysql
SQL