/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 vote113 views1 answer
Calculate date and convert to yearsmysql
SQL
1 vote119 views1 answer
Too many connections mysql
SQL
0 vote124 views1 answer
Returning with sqlalchemy
SQL
0 vote124 views1 answer
Get foreign table names mysql
SQL
8 votes118 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote130 views1 answer
Replace \n sql
SQL
1 vote128 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote189 views1 answer
Check user sql password from command line
SQL
2 votes150 views1 answer
Laravel sql String
SQL
0 vote123 views1 answer
C# mysql update statement set value to null
SQL