How do you create a table with an existing structure of another table with data and with no data?

Answer Posted / praveen kota

Create table tablename as existing tablename with (no) data

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2220


What do you mean by teradata sql assistant?

781


Explain the term 'tables' related to relational database management system?

814


What is meant by a Virtual Disk?

837


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1826


What is teradata?

854


Why does varchar occupy 2 extra bytes?

851


What are default access rights in teradata?

857


What are the different table types that are supported by teradata?

767


What do you mean by teradata intelliflex?

848


What is the use of fallback?

771


Explain the term 'database' related to relational database management system?

777


What is called partitioned primary index (ppi)?

760


Explain the teradata primary index mechanics in detail with a diagram.

758


What is meant by a dispatcher?

791