/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

32 votes133 views6 answers
Insert select
SQL
0 vote144 views1 answer
Get id if is not equal in certain table
SQL
8 votes128 views3 answers
Duplicate entry
SQL
0 vote131 views1 answer
Select from another database
SQL
2 votes134 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote135 views1 answer
Rabbitmq service not starting
SQL
0 vote139 views1 answer
Oracle current session details
SQL
0 vote138 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote141 views2 answers
Mysql limit offset
SQL
0 vote136 views1 answer
Sql server select record with max id
SQL