/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

1 vote256 views1 answer
GROUP BY clause; this is incompati
SQL
4 votes288 views2 answers
Dbms output
SQL
0 vote272 views1 answer
Mariadb hours between two dates
SQL
0 vote290 views1 answer
SQL Server date literal
SQL
0 vote278 views1 answer
Change redo log file size in mysql 5.6
SQL
3 votes281 views1 answer
How to find names includes in sql
SQL
0 vote291 views1 answer
Mysql uuid
SQL
0 vote267 views1 answer
Oracle gather table statistics
SQL
1 vote283 views1 answer
Continue in sql
SQL
1 vote280 views1 answer
Import mysql dump database command line linux
SQL