TheDeveloperBlog.com
C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
SQL Table
SQL table query with sql, tutorial, examples, insert, update, delete, select, join, database, table, join
SQL TableTable is a collection of data, organized in terms of rows and columns. In DBMS term, table is known as relation and row as tuple. Note: A table has a specified number of columns, but can have any number of rows.Table is the simple form of data storage. A table is also considered as a convenient representation of relations. Let's see an example of an employee table:
In the above table, "Employee" is the table name, "EMP_NAME", "ADDRESS" and "SALARY" are the column names. The combination of data of multiple columns forms a row e.g. "Ankit", "Lucknow" and 15000 are the data of one row. SQL TABLE Variable
The SQL Table variable is used to create, modify, rename, copy and delete tables. Table variable was introduced by Microsoft. It was introduced with SQL server 2000 to be an alternative of temporary tables. It is a variable where we temporary store records and results. This is same like temp table but in the case of temp table we need to explicitly drop it. Table variables are used to store a set of records. So declaration syntax generally looks like CREATE TABLE syntax.
create table "tablename"
("column1" "data type",
"column2" "data type",
...
"columnN" "data type");
When a transaction rolled back the data associated with table variable is not rolled back. A table variable generally uses lesser resources than a temporary variable. Table variable cannot be used as an input or an output parameter. Topics of SQL TABLE Statement
SQL TABLE Variable
What TABLE variable can do? SQL CREATE TABLEHow to create a table using SQL query> SQL DROP TABLEHow to drop a table? SQL DELETE TABLEHow to delete all the records of a table? How to rename a table? SQL TRUNCATE TABLEHow to truncate a table? SQL COPY TABLEHow to copy a table? SQL TEMP TABLEWhat is temporary table? What are the advantage of temporary table? SQL ALTER TABLEHow to add, modify, rename and drop column.
Next TopicSQL Create Table
|
Related Links:
- SQL Interview Questions (2021)
- Learn SQL Tutorial
- Top 45 SQL Server Interview Questions (2021)
- SQL SELECT RANDOM
- SQL SELECT AS
- SQL SELECT IN
- SQL SELECT from multiple tables
- SQL SELECT DATE
- SQL SELECT SUM
- SQL SELECT NULL
- SQL WHERE
- SQL AND
- SQL OR
- SQL WITH
- SQL ORDER BY ASC
- SQL ORDER BY DESC
- SQL ORDER BY RANDOM
- Learn Sql Server Tutorial
- SQL ORDER BY LIMIT
- SQL ORDER BY Multiple Columns
- SQL INSERT
- SQL INSERT Multiple Rows
- SQL UPDATE
- SQL UPDATE with JOIN
- SQL UPDATE DATE
- SQL DELETE
- SQL DELETE ROW
- SQL DELETE all rows
- SQL DELETE JOIN
- SQL DELETE duplicate rows
- SQL DELETE DATABASE
- SQL DELETE VIEW
- SQL JOIN
- SQL OUTER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL JOIN
- SQL CROSS JOIN
- SQL PRIMARY KEY
- SQL FOREIGN KEY
- SQL COMPOSITE KEY
- SQL vs NoSQL
- SQL Quiz | SQL Online Test
- SQL vs SQLite
- SQL Data Types
- SQL Operators
- SQL CREATE Database
- SQL DROP Database
- SQL Syntax
- SQL RENAME Database
- SQL SELECT Database
- SQL Table
- SQL CREATE Table
- SQL DROP Table
- SQL DELETE TABLE
- SQL RENAME Table
- SQL TRUNCATE Table
- SQL COPY Table
- SQL SELECT COUNT
- SQL SELECT TOP
- SQL ORDER BY
- SQL TEMP Table
- SQL ALTER Table
- SQL SELECT
- SQL SELECT UNIQUE
- SQL SELECT DISTINCT
- SQL SELECT FIRST
- SQL SELECT LAST