表结构查询
sp_help t_table
sp_columns t_table
当前登陆用户下的所有表名
select name from sys.objects where type='U' order by name
select * from sys.objects where type='U' order by name
表结构查询
sp_help t_table
sp_columns t_table
当前登陆用户下的所有表名
select name from sys.objects where type='U' order by name
select * from sys.objects where type='U' order by name