Copy Table

1 min

Author

Marcel Ryser

Software architect and tech enthusiast from Berne, Switzerland

You can copy any table (data) with:

SELECT * INTO [NewTableName] FROM [TableName]

an example:

SELECT * INTO adress_backup FROM adress