/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 vote209 views1 answer
Oracle show grants on table
SQL
5 votes186 views2 answers
Copy data from one database to another
SQL
0 vote229 views1 answer
Ms sql print more than 1 variable
SQL
14 votes200 views4 answers
Import database through command line
SQL
1 vote190 views2 answers
Mysql current user
SQL
1 vote176 views1 answer
Delete triger pl pg sql
SQL
0 vote204 views1 answer
Proc sql not in working
SQL
0 vote196 views1 answer
How to update sql server version
SQL
5 votes190 views3 answers
Truncate function in sql oracle
SQL
0 vote179 views1 answer
Show specific events on mysql
SQL