/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 votes135 views6 answers
Rename column mysql
SQL
1 vote110 views1 answer
Importance of comment in mysql
SQL
20 votes118 views4 answers
Sqlite create table if not exists
SQL
8 votes115 views4 answers
Mysql update one table from another table multiple columns
SQL
17 votes113 views6 answers
Mysql import sql file
SQL
2 votes121 views1 answer
Oracle to_char number format percentage
SQL
3 votes197 views2 answers
Savepoint in sql
SQL
0 vote116 views1 answer
Windows services sql
SQL
0 vote124 views4 answers
How to drop all tables in sql
SQL
0 vote115 views1 answer
C# check if mysql query modified rows
SQL