Member Avatar for ramendra.saini

hi any body plz help me I want to create new table from an existing table with data and definition.

  • 2 Contributors
  • 1 Reply
  • 29 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by pritesh2010
Member Avatar for pritesh2010

just wirte this query

SELECT * INTO NewTable FROM OldTable

your oldtable data will be copy in newtable.which will create when you fire this query.
mark this thread as solved

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.