/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 vote254 views1 answer
Mysql select utc time in eastern time
SQL
0 vote232 views1 answer
Sql select rows with simlar names
SQL
0 vote295 views1 answer
Create a sql server database programmatically
SQL
0 vote250 views1 answer
Mysql earlier than date
SQL
0 vote289 views1 answer
Sql last 3 rows
SQL
27 votes286 views3 answers
Mysql show tables in database
SQL
-1 vote279 views3 answers
SQL to LINQ converter
SQL
14 votes269 views2 answers
Sql cast
SQL
1 vote302 views2 answers
Oracle leftmost characters
SQL
0 vote287 views1 answer
Stored function in sql
SQL