/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 vote343 views1 answer
Sql express database size limit
SQL
0 vote339 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote319 views1 answer
When mysql server would not work in xampp
SQL
0 vote305 views1 answer
Update set with inner join oracle
SQL
4 votes326 views1 answer
Oracle error line
SQL
24 votes305 views4 answers
How to add column sql
SQL
2 votes324 views2 answers
Sql percentage
SQL
1 vote315 views1 answer
How to use a trigger to validate input data
SQL
0 vote330 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
10 votes279 views2 answers
Django mysql
SQL