Kbase P97070: How to create a sql script for my table in sql server using SQL Server tools?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/11/2004 |
|
Status: Unverified
GOAL:
How to create a sql script for my table in sql server using SQL Server tools?
GOAL:
How to create a sql script within sql server?
FACT(s) (Environment):
MS SQL
FIX:
You can create a SQL script by using the Generate SQL Script option through SQL Server Enterprise Manager
1. Open SQL Server Enterprise Manager
2. Select and expand your database.
3. Select the table(s) that the .sql script needs to be created for
4. Once table has been selected, go to Tool menu and select "Generate SQL Script".
4. The Generate SQL Script Window will open
5. Select "Show All"
6. Enable "All tables"
7. All tables will show up on the right hand side
8. Select the table you want to run the sql script for. Remove the rest
9. Press okay and select a destination to where you want to save the .sql file