/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 votes332 views1 answer
Oracle log files
SQL
0 vote382 views1 answer
Transaction and commit trong sql server
SQL
0 vote335 views1 answer
Mariadb maximum left join
SQL
5 votes332 views1 answer
Oracle find foreign key dependencies
SQL
2 votes341 views1 answer
Sql server conection string
SQL
0 vote362 views1 answer
Uncheck constraints and delete from table
SQL
0 vote339 views1 answer
Mysql select where field is a value
SQL
4 votes334 views2 answers
Dbms_scheduler stop job
SQL
0 vote370 views1 answer
Trigger stock phpmyadmin
SQL
0 vote365 views1 answer
Psql initialization
SQL