Akılda kalacağına burada kalsın

DECLARE @collate nvarchar(100); DECLARE @table nvarchar(255); DECLARE @column_name nvarchar(255); DECLARE @column_id int; DECLARE @data_type nvarchar(255); DECLARE @max_length int; DECLARE @row_id int; DECLARE @sql nvarchar(max); DECLARE @sql_column nvarchar(max); SET @collate = 'Turkish_CI_AS'; DECLARE local_table_cursor CURSOR FOR SELECT [name] FROM sysobjects WHERE OBJECTPROPERTY(id, N'IsUserTable') = 1 OPEN local_table_cursor FETCH NEXT FROM local_table_cursor INTO @table WHILE @@FETCH_STATUS = 0 BEGIN     DECLARE local_change_cursor CURSOR FOR     SELECT ROW_NUMBER() OVER (ORDER BY c.column_id) AS row_id         , c.name column_name         , t.Name data_type         , c.max_length         , c.column_id     FROM sys.columns c     JOIN sys.types t ON c.system_type_id = t.system_type_id     LEFT OUTER JOIN sys.index_columns ic ON ic.object_id = c.object_id AND ic.column_id = c.column_id     LEFT OUTER JOIN sys.indexes i ON ic.object

as select * into <yenitabloadi> from <kaynaktabloadi> Örnek Select * into employee_backup from employee Belli kolonları atmak için  select col1, col2, col3 into < yenitabloadi > from < kaynaktabloadi > Örnek Select empId, empFirstName, empLastName, emgAge into employee_backup from employee Veriler haric sadece tablonun yapısını kurmak için. select * into < yenitabloadi > from < kaynaktabloadi > where 1 = 2 Örnek select * into employee_backup from employee where 1=2 Farklı veri tabanlarındaki tabloyu kopyalama select * into <yenitabloadi database .dbo.yenitabloadi> from <kaynaktabloadi database .dbo.kaynaktabloadi> Örnek select * into Mydatabase2.dbo.employee_backup from mydatabase1.dbo.employee