SQL 2005 / SQL Server Mgmt Studio "Script Table as"

Last Post 05 Feb 2009 09:56 AM by jbelisle. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

05 Feb 2009 09:56 AM
In SQL Server Mgmt Studio there is a feature to "Script Table as" let say SELECT...ie

SELECT [au_id]
FROM [Pubs].[dbo].[authors]

Are there some system calls within SQL DBMS that we can call to quickly gain access to these same scripting functions? Id like to make simple T-SQL calls to build some dynamic SQL based on these scripting outputs...don't wont to recreate the wheel if I don't have to.

Thanks in advance,

Acceptable Use Policy