/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

2 votes152 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote136 views1 answer
Events not working db
SQL
0 vote148 views1 answer
Sql dmv to capture updates
SQL
1 vote141 views1 answer
Oracle list datafiles in tablespace
SQL
1 vote131 views1 answer
Sql auto timestamp
SQL
2 votes145 views2 answers
Mysql get time from datetime
SQL
1 vote190 views1 answer
Add time to date sql
SQL
5 votes177 views1 answer
How to use rank function in sql
SQL
1 vote148 views1 answer
Oracle sql average
SQL
0 vote159 views1 answer
Snowflake drop column
SQL