![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
一批黑码
一个无知的程序猿
展开
-
sqlite 加密与连接
加密SQLiteConnection cnn = new SQLiteConnection($"Data Source = {sqliteFilePath}");cnn.Open();cnn.ChangePassword("your password");cnn.Close();连接加密数据库//System.Data.Sqlite uses a non standard encryption files encrypted by it are only read by system.data转载 2020-10-15 12:54:47 · 1539 阅读 · 0 评论 -
怎么用Sql语句获取一个数据库中的所有表的名字
查询数据库里所bai有表名du和字段名的语句1.SQL 查询所有表名zhi:SELECT NAME FROM SYSOBJECTS WHERE TYPE='U'SELECT * FROM INFORMATION_SCHEMA.TABLES2.查询表的所有字段名dao:SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID(' 表名' )SELECT * FROM INFORMATION_SCHEMA.TABLESSELECT * FROM INFORMA转载 2020-09-30 14:46:51 · 23139 阅读 · 0 评论