/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

11 votes211 views2 answers
MySQL DISTINCT
SQL
4 votes217 views1 answer
Oracle select first 10 rows
SQL
4 votes253 views1 answer
Sql delete multiple conditions
SQL
4 votes212 views3 answers
Mysql varchar length
SQL
0 vote212 views2 answers
Mysql disable foreign key checks
SQL
0 vote219 views1 answer
Create query in where clasue
SQL
0 vote215 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote231 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote219 views1 answer
Plsql check for string in numeric
SQL
0 vote216 views1 answer
Drop all procedures sql server
SQL