/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

20 votes140 views5 answers
Mysql reset auto increment to 1
SQL
0 vote134 views1 answer
Sql contains numeric characters
SQL
1 vote167 views1 answer
Mysql return text after a final full stop
SQL
2 votes155 views1 answer
Sql skip the first row
SQL
9 votes136 views2 answers
Sql server check table exists
SQL
1 vote140 views1 answer
Simple project for database
SQL
0 vote140 views1 answer
Normalization in database 2nd normal form
SQL
0 vote146 views1 answer
Sql doesn't contain
SQL
2 votes153 views1 answer
Guid to string sql
SQL
1 vote139 views1 answer
Right outer vs left outer join
SQL