/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 vote192 views1 answer
Sql on-premises
SQL
1 vote180 views1 answer
Get table column names sql ssms
SQL
0 vote248 views1 answer
Best sql collation
SQL
4 votes271 views4 answers
Update select mysql
SQL
0 vote192 views1 answer
Interview experience as a call?
SQL
0 vote184 views1 answer
Mysql table variables
SQL
1 vote267 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
13 votes179 views6 answers
Mysql update from select
SQL
1 vote199 views2 answers
Setval max id postgresql sequence
SQL
0 vote176 views1 answer
How to check if there is no database schema
SQL