/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

2 votes148 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
14 votes166 views2 answers
Oracle add attribute to table
SQL
7 votes142 views3 answers
Postgresql dump and restore db
SQL
17 votes157 views4 answers
Set mysql Password
SQL
0 vote153 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote148 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
16 votes143 views2 answers
Add column to all tables after first column mysql
SQL
0 vote104 views1 answer
Update sql join multiple tables
SQL
0 vote164 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote151 views1 answer
Sql server set complex constraints
SQL