/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

35 votes240 views6 answers
Postgres
SQL
6 votes255 views2 answers
Sql sequence
SQL
1 vote244 views1 answer
Too many connections mysql
SQL
10 votes236 views2 answers
Rtrim sql
SQL
0 vote250 views1 answer
Postgres populate table from another table
SQL
0 vote221 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote227 views1 answer
Get server date mysql
SQL
1 vote226 views1 answer
Sample in sql
SQL
2 votes225 views1 answer
No data found oracle
SQL
0 vote259 views1 answer
View t-sql mail configuration
SQL