/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

10 votes181 views2 answers
Forgot my mysql password mac
SQL
1 vote236 views1 answer
Oracle transaction rollback not working
SQL
0 vote163 views1 answer
Mysql remove tabs from string
SQL
3 votes182 views2 answers
Postgresql select all column names
SQL
0 vote180 views2 answers
List all constraints in postgres
SQL
11 votes198 views3 answers
Change column name sql server management studio
SQL
2 votes214 views1 answer
Mariadb json select
SQL
3 votes220 views2 answers
Enter mysql command line
SQL
0 vote187 views1 answer
Safe mysql
SQL
1 vote184 views1 answer
Mysql strict_trans_tables
SQL