/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 vote90 views1 answer
Split a string with expression and get the last value of split sql
SQL
17 votes132 views4 answers
Set mysql Password
SQL
0 vote145 views1 answer
Oracle show grants on table
SQL
2 votes130 views1 answer
Select * from table where name like
SQL
3 votes121 views2 answers
Mysql add 2 hours
SQL
0 vote131 views1 answer
Grepper sql workbench download
SQL
1 vote153 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote137 views1 answer
Sql query for displaying age from oldest to youngest
SQL
3 votes133 views1 answer
Async await mysql nodejs
SQL
0 vote126 views2 answers
Raise notice in postgresql function
SQL