/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 vote151 views1 answer
Drop a view in sqlite
SQL
0 vote73 views2 answers
Delete the last item in a table sql
SQL
0 vote103 views1 answer
Wordpress database query change url
SQL
0 vote112 views1 answer
Oracle table free space
SQL
0 vote111 views1 answer
Every Derived yable must have its own alias
SQL
4 votes121 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote102 views1 answer
Mysql command prompt date insert format
SQL
4 votes129 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote98 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote111 views1 answer
How to add timestamp column in mysql
SQL