/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 vote179 views2 answers
Mysql two column combination unique
SQL
4 votes146 views1 answer
Oracle sleep
SQL
0 vote184 views1 answer
Dns slave zone convert
SQL
7 votes173 views6 answers
Reset identity column in sql server
SQL
0 vote227 views1 answer
Alter fedora mysql 8.0 user
SQL
12 votes184 views2 answers
Insert multiple rows from another table sql
SQL
0 vote188 views1 answer
Convert sql server guid to varbinary
SQL
0 vote177 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote203 views1 answer
Nuget sqllite-net-pcl
SQL
1 vote189 views1 answer
Mysql backup skip table
SQL