YongGang Meng's Weblog


Welcome to Weblog

Browse by Tags

All Tags » SQL (RSS)
SQL 表信息问题
若要查看表的列名,可以使用 sp_help 或下列查询之一:SELECT name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID ('table_name')) 或 SELECT TOP 0 * FROM table_name。 1. Execute sp_help tablename 如: Execute sp_help 'Schedule' 2. Select Top 0 * From tablename 如:Select Top...
Posted: Nov 28 2008, 07:54 PM by Ralax | with no comments
Filed under: ,
More Posts