/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 vote219 views1 answer
How to move a column to different spot mysql
SQL
2 votes201 views3 answers
Current month mysql query
SQL
0 vote196 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote211 views1 answer
Heidisql check how much space a row
SQL
2 votes204 views1 answer
Q operator in plsql
SQL
0 vote196 views5 answers
Linq cheat sheet
SQL
1 vote196 views3 answers
Mariadb add foreign key
SQL
0 vote259 views1 answer
Sql from null to not null
SQL
15 votes204 views6 answers
Psql
SQL
2 votes201 views1 answer
Update trigger
SQL