get table names and table columns from db

来源:互联网 发布:键盘按键替换软件 编辑:程序博客网 时间:2024/06/05 06:46

private const string SqlGetAllTables = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' ";private string SqlGetAllColumns = "SELECT COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='{0}' ORDER BY ORDINAL_POSITION";


原创粉丝点击