Sample template for creating a table in sql servercis given below:
-----------------------------------------------------------------------------
/*******************************************************
*This script file creates the table TBL_TABLE_NAME *
*******************************************************/
/*******************************************************
====== BEGIN MAINTENANCE WRAPPER ==========
*******************************************************/
-- Check if the table already exists
IF EXISTS ( SELECT 1 FROM sysobjects-----------------------------------------------------------------------------
/*******************************************************
*This script file creates the table TBL_TABLE_NAME *
*******************************************************/
/*******************************************************
====== BEGIN MAINTENANCE WRAPPER ==========
*******************************************************/
-- Check if the table already exists
WHERE name = 'TBL_TABLE_NAME'
AND uid = user_id('dbo')
AND type = 'U')
-- P = Proc; V = View; U = Table; TR = Trigger
BEGIN
-- If it exists, drop to recreate the table
DROP TABLE dbo.TBL_TABLE_NAME
PRINT 'TABLE TBL_TABLE_NAME DROPPED SUCCESSFULLY'
END
ELSE
BEGIN
PRINT 'TABLE TBL_TABLE_NAME DROPPED FAILED'
END
GO
/********************************************************
====== END MAINTENANCE WRAPPER =========
*******************************************************/
/********************************************************
** REVISION HISTORY : *
** ====================== *
** DATE VERSION NAME COMMENTS *
** ---------- ------- ----------------- -----------------*
** MM/DD/CCYY 1.0 Developer Name Initial Draft *
** *
*****************************************************************/
CREATE TABLE dbo.TBL_TABLE_NAME
(
/* Table Body */
)
GO
/******************************************************************
======== BEGIN MAINTENANCE WRAPPER ==========
******************************************************************/
-- Check for errors in creating the table
IF EXISTS ( SELECT 1
FROM sysobjects
WHERE name = 'TBL_TABLE_NAME'
AND uid = user_id('dbo')
AND type = 'U')
-- P = Proc; V = View; U = Table; TR = Trigger
BEGIN
PRINT 'TABLE TBL_TABLE_NAME CREATED SUCCESSFULLY'
END
ELSE
BEGIN
PRINT 'TABLE TBL_TABLE_NAME CREATION FAILED'
END
GO
/******************************************************************
======== END MAINTENANCE WRAPPER ==========
******************************************************************/
-- SELECT * FROM dbo.TBL_TABLE_NAME
