/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 vote318 views1 answer
Oracle sql create or replace view
SQL
10 votes429 views4 answers
Sql server pagination
SQL
5 votes368 views4 answers
Mysql update column with value from another table
SQL
5 votes331 views1 answer
Purge undo tablespace oracle 11g
SQL
1 vote340 views1 answer
Wordpress change url phpmyadmin
SQL
5 votes320 views2 answers
Mysql drop table cascade
SQL
0 vote320 views1 answer
Remove default constraint sql server
SQL
-1 vote396 views1 answer
How to Activate the database
SQL
1 vote341 views1 answer
Quit mysql
SQL
0 vote320 views1 answer
Events not working db
SQL