What is a LIKE table and how is it created ?
A LIKE table is created by using the LIKE parameter in a CREATE table statement. LIKE tables are typically created for a test environment from the production environment.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Where data is stored in XML? 22.11.08
XML data is stored as column data. Data is stored in a data base (Depends on the machine it's running). A main table is created in a relational database managem...Why temporary records are needed? 17.11.08
Defines the record definition as a temporary table. Temporary images of the table can be created, specified by the PeopleTools Options Page. Temporary tables ar...How To Create a Table? 06.11.08
If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: Remember that mysql_query() returns TR...What is the difference between view and materialized view? 20.09.08
View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. Materialized view -...How do I get the date the object was created ? 21.07.08
To get the date the object was created, you can query the sysobjects system table to see the crdate column. This is the example to get the date the authors tabl...What is the difference between SYNONYM and ALIAS ? 20.03.08
SYNONYM : is dropped when the table or tablespace is dropped. Synonym is available only to the creator. ALIAS : is retained even if table...What information can you find in SYSIBM.SYSLINKS table ? 12.03.08
The SYSIBM.SYSLINKS table contains information about the links between tables created by referential constraints....What happens when a table is activated in DD? 05.04.07
When the table is activated, a physical table definition is created in the database for the table definition stored in the ABAP dictionary. The table definition...What is snapshot log? 14.11.06
It is a table that maintains a record of modifications to the master table in a snapshot. It is stored in the same database as master table and is only availabl...What are indexes? 12.03.06
Indexes are described as a copy of a database table reduced to specific fields. This data exists in sorted form. This sorting form ease fast access to the field...