Search found 3 matches

by johnwright456
27 May 2011 2:39
Forum: Scripts
Topic: Delete a table from command line
Replies: 13
Views: 32484

Let's say you need to drop all tables in a mysql database. How do you do that? You could use a gui, but that's not fun. You're a shell jockey so you want a commandline: mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | \ gawk '{print "drop table " $1 ";"}' | mysql -u uname d...
by johnwright456
27 May 2011 2:36
Forum: Scripts
Topic: Create a new table without scheduling table manager
Replies: 5
Views: 15086

Use this procedure to create a schedule table tool and add it to a tool palette. You may want to create your own schedule table tools if you are placing multiple schedule tables of specific styles that have the same properties. Open the tool palette on which you want to create a tool. Create the too...
by johnwright456
27 May 2011 2:29
Forum: SQL Scripts
Topic: Problem in sql script?
Replies: 1
Views: 6295

Try putting

USE [master]
GO

Before the CREATE DATABASE. Also make sure you login with a user that can actually CREATE a database (Login->Server Roles and Permissions tabs, under SSMS).