日期:2014-05-17 浏览次数:20690 次
-- =============================================
-- Create table basic template
-- =============================================
IF EXISTS(SELECT name 
      FROM      sysobjects 
      WHERE  name = N'<table_name, sysname, test_table>' 
      AND      type = 'U')
    DROP TABLE <table_name, sysname, test_table>
GO
CREATE TABLE <table_name, sysname, test_table> (
<column_1, sysname, c1> <datatype_for_column_1, , int> NULL, 
<column_2, sysname, c2> <datatype_for_column_2, , int> NOT NULL)
GO