0
no. a new table does not exist after a join command. All that is doing is temporarily pulling the data from the tables. If this command was one that you would want to do often, you can create a VIEW, which is a virtual table. It is an object that pulls data from one or more tables based on your search criteria.
Wiki User
∙ 16y ago
Add your answer:
Earn +20 pts
What does SQL error code consist of?
It consist of the ORA error and its description. example: ORA-00942 table or view does not exist
What is hash table in sql?
temp table
Which command is used to new table in the RDBMS?
In a relational database management system (RDBMS), the command for creating a new table is "CREATE TABLE". This is the standard in most SQL programs.
What is the name of two DDL operations in SQL?
Some of the operations performed in DDL in sql are creation of table,alteration of table,truncate a table, drop a table
Difference between table and index in sql?
A table is a collection of data that is organized into rows and columns. An index is a data structure that improves the performance of data fetch operations on a table. A table can exist as a standalone component but an index cannot. Indexes are built on top of tables and cannot exist without tables.
What is a sql virtual table called?
Trigger.
What date functions exist in SQL?
The date functions that exist in SQL are "NOW()", "CURDATE()", "CURTIME()", "DATE()", "EXTRACT()", "DATEDIFF()", "GETDATE()", "DATEPART()", and "CONVERT()".
Where online can one find information about SQL inner joins?
Information about SQL inner joins can be found on several sights. The best place if you are looking for something specific would be on a blog. W3schools, Tutorials Point, Tech on the Net, and Wikipedia has basic information.
Can you add new columns to a database after creating the structure?
Columns are added to a table, not a database (which is a collection of tables). Adding a column to a table is achieved by using the Alter Table SQL command.
What is the function of a Foreign Key in SQL?
foreign key in the sql is to query on the related information aavailable in the table.
Will SQL training teach me how to use the INNER JOIN command?
SQL is a mostly standard language that allows for analysis and presentation of data stored in a database. The INNER JOIN command is one of the basic SQL commands. SQL training will teach you how to use this command, as well as the commands that result in other types of joins, like outer joins, left outer joins, etc. The best SQL training sources will present you with a simple set of raw data and examples of the result sets generated from each type of query. Be aware that there are several similar versions of SQL that vary with each target database (SQL Server, DB2, etc.) so be sure that the training you sign up for is specific to the database that you intend to use.
What does SQL CREATE VIEW achieve?
SQL CREATE VIEW achieves the creation of a table or tables in the SQL database. One can then create tables to the purpose they desire and fill them in with information.
