USP_DATABASESPACEUSED_GETTABLES

Definition

Copy


CREATE procedure dbo.[USP_DATABASESPACEUSED_GETTABLES]
with execute as owner
as begin
  set nocount on;

  select schema_name(schema_id) as [SCHEMA], name as [NAME] from sys.objects where type = 'U';

  return 0;
end