Article 3.6.1AD: In SQL, how to clear all the rows in one query?
If you want to delete all the rows in a table, use the below command.
Click new query and type this command - truncate table "TableName".
FYR - Kindly have a look at the attached image.
Related Articles
Article 3.6.1T : How to copy SQL Data from one table to another table ?
1. SET NOCOUNT ON SET STATISTICS TIME ON INSERT INTO Table_name_one ( colm1, colm2, colm3, colm4, colm5 ) SELECT colm1, colm2, colm3, colm4, colm5, FROM Table_name_two SET STATISTICS TIME OFF SET NOCOUNT OFF Note: Before ...
Article 3.6 SQL 2019 Installation Guide
Please find the attachment
Article 3.6.1AE : How to check Live Data in a SQL?
First, open the SQL server management studio (SSMS) and log in with the user id and password. After that follow below hierarchy to get Online data from SQL. ElNetDB > dbo.LiveData > Edit Top 200 Rows. You will find the table of the list of the meter ...
Article 3.1.45S : SQL Configurator Manager is not showing in system
If SQL Configurator manager is not showing in system follow below process to find. Go to C Drive -> Windows - > System 32 - > SQL server manager - > Open
Article 3.6.5S : How to check Server name and PW of SQL?
Yes, we can know the server name and Password of the SQL server management studio. With the help of ElNet master application is available in the software installation folder in the server PC program file. Click on ElNet master and we can know the SQL ...