/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 vote200 views1 answer
Updating database in sql
SQL
1 vote184 views1 answer
Sql server 2012 query history
SQL
-1 vote192 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote182 views1 answer
Sql create table with references not primary key
SQL
0 vote185 views1 answer
Mysql workbench not showing schemas
SQL
2 votes210 views1 answer
Capitalize 1st letter in sql server
SQL
2 votes186 views1 answer
Apex date today add days
SQL
0 vote187 views1 answer
Apex for oracle 11g
SQL
3 votes271 views4 answers
Sql interview questions
SQL
0 vote200 views1 answer
Compare subqueries oracle
SQL