Sql语句常用的关键词 - SqlName

2017-02-20 16:03:15 访问(1392) 赞(0) 踩(0)

using System;
using System.Collections.Generic;
using System.Text;

namespace SlowX.Common
{
    /// <summary>
    /// Sql语句常用的关键词 - SqlName
    /// </summary>
    [Serializable]
    public class SqlName
    {
        /// <summary>
        /// select
        /// </summary>
        public const string select = "select";

        /// <summary>
        /// order
        /// </summary>
        public const string order = "order";

        /// <summary>
        /// by
        /// </summary>
        public const string by = "by";

        /// <summary>
        /// where
        /// </summary>
        public const string where = "where";

        /// <summary>
        /// from
        /// </summary>
        public const string from = "from";

        /// <summary>
        /// distinct
        /// </summary>
        public const string distinct = "distinct";

        /// <summary>
        /// having
        /// </summary>
        public const string having = "having";

        /// <summary>
        /// group
        /// </summary>
        public const string group = "group";

        /// <summary>
        /// min
        /// </summary>
        public const string min = "min";

        /// <summary>
        /// max
        /// </summary>
        public const string max = "max";

        /// <summary>
        /// avg
        /// </summary>
        public const string avg = "avg";

        /// <summary>
        /// sum
        /// </summary>
        public const string sum = "sum";

        /// <summary>
        /// nvl
        /// </summary>
        public const string nvl = "nvl";

        /// <summary>
        /// count
        /// </summary>
        public const string count = "count";

        /// <summary>
        /// delete
        /// </summary>
        public const string delete = "delete";

        /// <summary>
        /// insert
        /// </summary>
        public const string insert = "insert";

        /// <summary>
        /// update
        /// </summary>
        public const string update = "update";

        /// <summary>
        /// asc
        /// </summary>
        public const string asc = "asc";

        /// <summary>
        /// desc
        /// </summary>
        public const string desc = "desc";


        /// <summary>
        /// alter
        /// </summary>
        public const string alter = "alter";
         
        /// <summary>
        /// table
        /// </summary>
        public const string table = "table";

        /// <summary>
        /// drop
        /// </summary>
        public const string drop = "drop";

        /// <summary>
        /// identity
        /// </summary>
        public const string identity = "identity";

        /// <summary>
        /// @@IDENTITY
        /// </summary>
        public const string __IDENTITY = "@@IDENTITY";

        /// <summary>
        /// sequence 序列号
        /// </summary>
        public const string sequence = "sequence";

        /// <summary>
        /// primary 关键字
        /// </summary>
        public const string primary = "primary";

        /// <summary>
        /// truncate 清空
        /// </summary>
        public const string truncate = "truncate";

        /// <summary>
        /// create 创建
        /// </summary>
        public const string create = "create";

        /// <summary>
        /// foreign
        /// </summary>
        public const string foreign = "foreign";
        
        /// <summary>
        /// key
        /// </summary>
        public const string key = "key";

        /// <summary>
        /// references
        /// </summary>
        public const string references = "references";

        /// <summary>
        /// unique 唯一性
        /// </summary>
        public const string unique = "unique";

        /// <summary>
        /// datetime
        /// </summary>
        public const string _datetime = "datetime";

        /// <summary>
        /// int
        /// </summary>
        public const string _int = "int";

        /// <summary>
        /// nvarchar
        /// </summary>
        public const string _nvarchar = "nvarchar";

        /// <summary>
        /// bigint
        /// </summary>
        public const string _bigint = "bigint";

        /// <summary>
        /// decimal
        /// </summary>
        public const string _decimal = "decimal";

        /// <summary>
        /// char
        /// </summary>
        public const string _char = "char";

        /// <summary>
        /// ntext
        /// </summary>
        public const string _ntext = "ntext";

        /// <summary>
        /// default
        /// </summary>
        public const string _default = "default";

        /// <summary>
        /// number
        /// </summary>
        public const string _number = "number";

        /// <summary>
        /// getdate
        /// </summary>
        public const string getdate = "getdate";

        /// <summary>
        /// sysdate
        /// </summary>
        public const string sysdate = "sysdate";

        /// <summary>
        /// values
        /// </summary>
        public const string values = "values";

        /// <summary>
        /// column
        /// </summary>
        public const string column = "column";


    }
}