/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 vote256 views1 answer
See the structure of a table mysql
SQL
0 vote268 views2 answers
Postgres isnull
SQL
2 votes227 views1 answer
Sql update alias
SQL
2 votes219 views1 answer
Check isolation level in mysql
SQL
0 vote220 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
11 votes245 views5 answers
Laravel db facade
SQL
59 votes353 views6 answers
Alter table sql
SQL
0 vote217 views1 answer
Limiting query result using where in sql
SQL
1 vote241 views1 answer
Oracle sequence last_number
SQL
10 votes243 views2 answers
SQL rounding numbers
SQL