Sql

Search

shrink database file in sql server

USE SampleDataBase;
GO
-- Shrink the mdf file
DBCC SHRINKFILE(N'SampleDataBase', 0);
GO
-- Shrink the log.ldf file
DBCC SHRINKFILE(N'SampleDataBase_log', 0);
GO

Comment

PREVIOUS	NEXT

Code Example
Sql :: pl sql disable trigger
Sql :: insert value in identity
Sql :: create index concurrently postgres
Sql :: what is my mysql version
Sql :: insert data in pgsql
Sql :: postgres set default value
Sql :: mysql order
Sql :: delete top N rows in sql
Sql :: SQL Server Get the current identity value of the table
Sql :: how to get id of last inserted row in mysql
Sql :: To count number of rows in SQL table
Sql :: is mysql and sqlite same
Sql :: select and condition in sql
Sql :: Write a query to create an empty table from an existing table?
Sql :: how to get nearest location in mysql with latitude and longitude
Sql :: mysql add text to existing field
Sql :: create user sql server
Sql :: change database name psql 8
Sql :: add column if not exists mysql
Sql :: postgres list all triggers
Sql :: database disk image is malformed sqlite fix ubuntu
Sql :: savepoint in sql
Sql :: phpmyadmin change password
Sql :: get record which is available in one table but not in another mysql
Sql :: select new table sql
Sql :: sql percentage
Sql :: replace null value within column mysql
Sql :: postgre describe table
Sql :: laravel jwt
Sql :: copy value from one column to another postgres

Search

SQL

shrink database file in sql server

ADD CONTENT