/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 vote325 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote320 views1 answer
Query to insert image
SQL
-1 vote309 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote336 views1 answer
How to find lowest in sql
SQL
0 vote332 views1 answer
Change magento database url usimg musql
SQL
17 votes389 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote297 views0 answer
SQL
4 votes303 views1 answer
Oracle show error line number
SQL
3 votes311 views1 answer
Delete all content in table mysql
SQL
0 vote321 views1 answer
Mysql select where field is a value
SQL