/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 vote305 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
1 vote304 views1 answer
Insert column after column mysql
SQL
3 votes328 views1 answer
Create a table with an id in mysql
SQL
0 vote323 views3 answers
Join
SQL
-1 vote312 views1 answer
Mysql select count if contains
SQL
9 votes295 views4 answers
How to remove duplicate in sql
SQL
0 vote322 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote309 views1 answer
Sql values not in another table
SQL
0 vote338 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
4 votes292 views1 answer
Create column mysql terminal
SQL