<div>
<a href="http://stackoverflow.com/questions/1369551/list-of-tables-without-indexes-in-sql-2008" rel="ugc">http://stackoverflow.com/questions/1369551/list-of-tables-without-indexes-in-sql-2008</a>
</div>


http://stackoverflow.com/questions/1369551/list-of-tables-without-indexes-in-sql-2008 [http://stackoverflow.com/questions/1369551/list-of-tables-without-indexes-in-sql-2008]

<div>
<div class="content wysiwyg-content">
Hi,<br />
Can someone explain how dbo (database owner) works? &nbsp;I have most tables under dbo but there are some which are under different user.<br />
<br />
Also how can I use INFORMATION_SCHEMA to list details of tables,indexes ?<br />
<br />
Thanks
</div>
</div>


Hi,
Can someone explain how dbo (database owner) works?  I have most tables under dbo but there are some which are under different user.

Also how can I use INFORMATION_SCHEMA to list details of tables,indexes ?

Thanks

Details on SQL Server dbo and INFORMATION_SCHEMA

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.