/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

1 vote347 views1 answer
Postgres select as csv
SQL
10 votes379 views2 answers
What is database
SQL
1 vote348 views1 answer
Sql server get users
SQL
0 vote363 views5 answers
How to make trigger in phpmyadmin
SQL
18 votes335 views2 answers
Sql inner join
SQL
2 votes390 views3 answers
Postgres json to string
SQL
1 vote356 views1 answer
Postgres check for foreign key
SQL
-1 vote368 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote342 views1 answer
Sql last 7 days
SQL
1 vote360 views1 answer
Mysql size int
SQL