/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

3 votes143 views2 answers
Oracle apex view logs
SQL
0 vote128 views1 answer
Add sqlite3 in lumen
SQL
0 vote151 views1 answer
Wordpress sql find and replace
SQL
5 votes134 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote135 views1 answer
Connect postgresql using a connection string
SQL
0 vote127 views1 answer
How to output a different column name in mysql
SQL
1 vote130 views10 answers
Stack overflow
SQL
0 vote134 views1 answer
Postgresql copy backup table
SQL
3 votes126 views2 answers
Sql add year to date
SQL
-2 votes136 views1 answer
No module named '_sqlite3
SQL