Results 1 to 2 of 2

Thread: structure

  1. #1
    Join Date
    Feb 2004
    Posts
    19

    Unanswered: structure

    hi
    can i create a structure xxx of a table ttt such that it just has the structure of the table and no data.

    thanks
    kiran

  2. #2
    Join Date
    Nov 2003
    Posts
    33
    you can try following sql staments

    create table xxx as ( select * from ttt where 1= 0);

    or

    create table xxx as ( select * from ttt );

    truncate xxx;

    i hope this will work

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •