/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

16 votes187 views1 answer
Mysql mediumint max value
SQL
1 vote182 views1 answer
SQL query to get all table records count from a database
SQL
0 vote183 views1 answer
Drop a field in psql django
SQL
1 vote185 views1 answer
Date_part mysql
SQL
1 vote188 views1 answer
Timestamp in sqlite
SQL
0 vote183 views2 answers
Sqlite
SQL
0 vote193 views1 answer
Soql user profile
SQL
1 vote192 views2 answers
Change table name phpmyadmin
SQL
1 vote173 views1 answer
Mysql datetime with timezone offset
SQL
0 vote228 views1 answer
Change mysql version to 5.7 in ubuntu
SQL