/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 vote281 views1 answer
How to find sql server name
SQL
5 votes271 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote281 views2 answers
How to update date in oracle
SQL
1 vote328 views1 answer
Oracle select first row order by
SQL
0 vote277 views1 answer
Postgre admin slow
SQL
0 vote341 views1 answer
Sql server query all database objects
SQL
4 votes280 views1 answer
Postgresql create table with index
SQL
3 votes264 views1 answer
Pl sql check if variable is empty
SQL
0 vote303 views1 answer
Sql query to force the database to be drop
SQL
0 vote275 views1 answer
Docker export psql sql
SQL