ignas-sakalauskas

USE [YourDBName]
 
SELECT * FROM sys.Tables
SELECT * FROM sysobjects WHERE xtype='u'

-- https://ignas.me/tech/select-all-tables-database/

ignas-sakalauskas

using System.Net;
using Microsoft.AspNetCore.Mvc;

namespace WebApplication4.Controllers
{
    [Route("api/[controller]")]
    public class ValuesController : Controller
    {
        [HttpGet]
        public IActionResult Get()

ignas-sakalauskas

-- Database size in MB
SELECT
  SUM(reserved_page_count) * 8.0 / 1024 AS 'MB'
FROM sys.dm_db_partition_stats

-- https://ignas.me/tech/sql-database-tables-sizes/