/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

10 votes195 views1 answer
All_dependencies
SQL
7 votes196 views2 answers
Add column table pl sql
SQL
3 votes215 views4 answers
Psql list tables in schema
SQL
11 votes196 views4 answers
Query DISTINCT
SQL
2 votes205 views1 answer
Add default sql server
SQL
0 vote266 views1 answer
Php insert null mysql
SQL
0 vote209 views1 answer
How to input data as id in database sql c#
SQL
0 vote224 views1 answer
Sql cmd no truncate
SQL
0 vote202 views1 answer
Oracle list subpartitions
SQL
4 votes209 views1 answer
For loop postgresql
SQL