/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

3 votes250 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote247 views1 answer
Postgres regex remove special characters
SQL
9 votes242 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote250 views1 answer
Sql grant select only
SQL
0 vote253 views1 answer
Convert rows into columns in oracle
SQL
0 vote280 views2 answers
Mysql dump database tables only
SQL
0 vote258 views1 answer
Sql trigger to call stored procedure with parameters
SQL
1 vote282 views1 answer
Oracle see column type
SQL
11 votes266 views1 answer
Oracle view ddl
SQL
0 vote247 views1 answer
Oracle sqlp update amount / quantity
SQL