/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

18 votes341 views2 answers
Sql comments
SQL
0 vote392 views1 answer
Soql update query
SQL
1 vote354 views1 answer
Sql find column name like
SQL
0 vote435 views1 answer
Sql query inline if
SQL
-1 vote356 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote346 views1 answer
Json_remove mysql
SQL
0 vote729 views1 answer
Sql field equals multiple values
SQL
0 vote384 views2 answers
Sql day from datetime
SQL
0 vote380 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote350 views1 answer
Return size of tables in mysql
SQL