/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

-1 vote145 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote181 views2 answers
Sql update multiple tables
SQL
16 votes173 views6 answers
Python sqlite
SQL
0 vote140 views2 answers
Sqlite unix timestamp
SQL
2 votes144 views1 answer
Oracle drop table free up space
SQL
6 votes131 views5 answers
Get current date sql
SQL
0 vote154 views1 answer
Import mysql'
SQL
1 vote162 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote147 views1 answer
Psql select * from table
SQL
0 vote189 views1 answer
Insert into table with only identity column
SQL