Skip to main content

Create /drop Database or Table

  1. {CREATE | DROP} DATABASE – Used to create / alter / delete a database respectively.
    Ex: create/drop database TestDB (To created or drop TestDB)
  1. {CREATE | ALTER | DROP} TABLE – Used to add / modify / remove table in a database respectively (Ex : create table TableName(ColumnName1 datatype,ColumnName2 datatype,.. as so on),alter table TableName add Column ColumnName3 datatype: drop table TableName (to drop a table)
Labels:

Comments

Post a Comment

Popular posts from this blog

Export html table to csv using javascript

<table>     <tr><th>Name</th><th>Age</th><th>Country</th></tr>     <tr><td>MANOJ</td><td>26</td><td>INDIA</td></tr>     <tr><td>KRISHAN</td><td>19</td><td>INDIA</td></tr>     <tr><td>SUSHEEL</td><td>32</td><td>INDIA</td></tr> </table> <button onclick="Export_CSV ()">Export HTML table to CSV file</button> function download_csv(csv, filename) {     var csvFile;     var downloadLink;     csvFile = new Blob([csv], {type: "text/csv"});     downloadLink = document.createElement("a");     downloadLink.download = filename;     downloadLink.href = window.URL.createObjectURL(csvFile);     downloadLink.style.d...
Post a Comment
Read more

Difference between SQL Function and Stored Procedure

The main difference between functions and stored procedures  are given bellow: Function(User Defined) It returns only one value We can’t use transaction in function Only have input parameter We can’t called SP from function We can’t use exception handling using Try-Catch block in function We can use function in select/where/having statement Stored Procedure (Store Procedure) It returns zero, single or multiple values We can use transaction in SP Can have input/output parameter We can called function from SP We can use exception handling using Try-Catch block in SP We can’t use SP in select/where/having statement
Post a Comment
Read more