SQL Server
List tables and disk space in SQL Server
List tables and disk space in SQL Server database can be very convenient especially to analyze the disk usage and the free disk space used by each table. Three different ways, but similar are …
sys
SQL Server
Check last update date on a SQL Server table
How to check the last update date on a SQL Server table? Check the last access and update with a simple SQL query? Thanks to the SQL Server relational database management system tables, a …
SQL Server
List user defined table types in SQL Server
How to list User Defined Tables Types of your SQL Server database? First of all, users declare User Defined Table Type as a particular table structure in the database. A database user declares it …