摘要： -- To find all database names;select name from sys.databases;-- To find all table names under a databaseuse DBName;goselect name from sys.tables;-- To get column name, data type and length of a tableSELECT c.name 'Column Name', t.Name 'Data type', c.max_length 'Max Length'FRO 阅读全文

摘要： Create database SplitDBFile on primary( Name='SplitDBFile', filename='D:\SharedFolder\SplitDBFile.mdf', SIZE=50MB, FILEGROWTH=10%)use SplitDBFile;go-- [primary] must include []create table UserInfo ( ID int, Name varchar(10))on [primary]insert into UserInfo values (1,'1');-- 阅读全文