You see the table structure using SP_HELP..
sp_help table_name
Type: Posts; User: sundharmail; Keyword(s):
You see the table structure using SP_HELP..
sp_help table_name
Sorry Bhaski. I don't have idea in ORACLE
If it is SQL Server Then Use INTO functions
SELECT TOP 0 * INTO new_table_name FROM old_table_name
DECLARE @IntVariable int;
DECLARE @SQLString nvarchar(500);
DECLARE @ParmDefinition nvarchar(500);
DECLARE @max_title varchar(30);
SET @IntVariable = 197;
SET @SQLString = N'SELECT...
Using INTO we can copy..
SELECT TOP 0 * INTO New_Table_Name From Old_Table_Name
The Above query will come only the structure for the table..
If U want to copy with the data then remove the...
Using LinkedServer concept we can connect & get the data's from the 2 different database or different servers..
Using OPENDATASOURCE we can get it.
Syntax:
OPENDATASOURCE ( provider_name,...
using SP_HELP we can get it all the informations about the table..