/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 vote156 views1 answer
Mysql:5.6 syntax create table
SQL
3 votes155 views1 answer
Ms sql skip take
SQL
11 votes241 views1 answer
Oracle insert from select
SQL
1 vote225 views1 answer
Mysql is odd
SQL
0 vote193 views1 answer
Sql cheetsheet
SQL
2 votes158 views4 answers
Mysql get all tables row count
SQL
1 vote162 views1 answer
Select users with same username
SQL
0 vote204 views1 answer
Parent and child link in mysql
SQL
2 votes159 views2 answers
Postgres trigger insert into another table
SQL
52 votes730 views6 answers
Rename column sql
SQL