/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

1 vote117 views1 answer
Hackerrank sql test solutions
SQL
5 votes127 views4 answers
Mysql update column with value from another table
SQL
0 vote151 views2 answers
How to get max from each department in sql
SQL
0 vote115 views1 answer
Mysql find missing values
SQL
1 vote115 views2 answers
Pl sql case
SQL
1 vote125 views1 answer
Check if mysql is installed
SQL
2 votes121 views2 answers
Mysql user access to database
SQL
0 vote154 views1 answer
Oracle db timestamp auto add
SQL
0 vote127 views1 answer
Asp.net core sql server stored procedure
SQL
1 vote110 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL