List the Roles and table names of a SQL Server database

--Use YOUR DB nameselect QUOTENAME (schema_name (schema_id)) + '. ' + QUOTENAME (NAME) from SYS. Tablesselect ' [' + schema_name (schema_id) + ']. [' + name + '] ' from sys.tablesselect ' [' + Table_schema + ']. [' + table_name + '] ' from  information_schema. Tablesselect QuoteName (USER_NAME (UID)) + '. ' + QuoteName (object_name (ID)) as [Schema Table] from sysObjects where xtype = ' U '

Available in 4 different ways.

Execution Result:

Reference Source: http://blog.sqlauthority.com/2009/06/17/sql-server-list-schema-name-and-table-name-for-database/#comment-53071

End