/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 vote358 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
1 vote346 views3 answers
Java.sql.sqlexception: access denied for user
SQL
1 vote334 views1 answer
Ef core 5.0 usesqlserver not found
SQL
3 votes345 views1 answer
Oracle function return
SQL
16 votes334 views2 answers
Add column to all tables after first column mysql
SQL
0 vote315 views2 answers
Mysql disable foreign key checks
SQL
1 vote348 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote458 views1 answer
Php insert null mysql
SQL
8 votes380 views1 answer
See all users mysql
SQL
1 vote332 views4 answers
Postgres extract date from timestamp
SQL