/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 vote333 views1 answer
Postgres set column based on another column
SQL
3 votes203 views3 answers
Raw select laravel
SQL
0 vote356 views1 answer
How to use select union and loop
SQL
0 vote200 views1 answer
Mysql insert multiple rows based on select
SQL
1 vote191 views1 answer
Mysql current time
SQL
0 vote199 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
18 votes195 views2 answers
Sql inner join
SQL
23 votes204 views5 answers
Sql substring
SQL
4 votes210 views2 answers
Bulk kill mysql processlist
SQL
8 votes163 views1 answer
Similarities between ddl and dml
SQL